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) |