Question

A retail company is migrating a 4 TB self-managed PostgreSQL database from an on-premises data center to Cloud SQL for PostgreSQL. The business requires the application to remain available during the migration, with only a brief cutover window of a few minutes. The team wants a managed approach that continuously replicates changes from the source until they are ready to switch over. Which migration strategy should they use?

Accepted Answer

Use Database Migration Service to perform a continuous migration job that replicates ongoing changes until the team promotes the destination during a short cutover window.

Answer

Export the source database with pg_dump, upload the dump file to Cloud Storage, and import it into Cloud SQL during a scheduled maintenance outage.

Answer

Take a nightly disk snapshot of the on-premises server, transfer it via Transfer Appliance, and restore it into Cloud SQL.

Answer

Set up a one-time BigQuery Data Transfer Service job to copy the tables and then point the application to BigQuery.