Data migration can happen if the source database server is stopped for writing, that is, offloaded (cold DB), or when the source database server continues running normally (hot DB).

To migrate a cold DB, it suffices to run procopy. When the DB does not change, procopy can load the whole DB to the destination keeping the data consistent.

To perform a complete migration of a hot DB, both procopy and prosync are needed. For more details, see prosync Usage.

To migrate a hot DB, the destination DB must have unique keys and indexes. Otherwise, duplicate data can occur. To migrate a table without unique keys (heap), the cold DB must be migrated. For PostgreSQL/Postgres Pro sources, a snapshot can also be specified (see the section called “Configuring Tasks to Specify a Snapshot” for more details).