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)