Database-independent synchronization strategy that does full record transfer between two databases.
This strategy is best used when there are
many differences between the active database and the inactive database (i.e. very much out of sync).
The following algorithm is used:
- Drop the foreign keys on the inactive database (to avoid integrity constraint violations)
- For each database table:
- Delete all rows in the inactive database table
- Query all rows on the active database table
- For each row in active database table:
- Insert new row into inactive database table
- Re-create the foreign keys on the inactive database
- Synchronize sequences