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