Migration Script: Only copy CI data to new ci database
We have a rake task that copies the database structure and data from the main
database to the ci
database.
This script is using pg_dump to dump the database and then pg_restore to restore the database into CI
database.
During test of migrating a 95Gb database, we learned that the entire process can take more than 1.5 - 2 hours.
A possible way of reducing this time could be:
- Duplicate the database structure from
main
toci
- But only copy data for tables that belong to
ci
schema
Edited by Rutger Wessels