The Backup / Restore approach
Using this approach means that we use the built in methods of the database and file system to first make a backup of the entire data and then restore it elsewhere.
| Pros | Cons | 
|---|---|
| IDs and Properties will be retained | All data, no selection | 
| History is included | Multiple tools must be used | 
| Is potentially faster | Systems must be offline during backup | 
| Potentially larger size | |
| Possible upgrade of source system required or installation ofsame version as source system in the target system (backup filesmust be compatible between databases) |