Database Migration Service provides a lot of flexibility for your homogeneous PostgreSQL migrations to Cloud SQL for PostgreSQL. Depending on your database size, downtime requirements, and networking setup, there are different workflows available to best meet your scenario. Detailed networking and other prerequisites are described in each migration guide.
The following table provides an overview of each migration flow:
| Migration workflow | Best suited for | Description |
|---|---|---|
| Migrate to a new destination instance | Standard migrations where you want to create a clean target instance tailored for the migration workload. | Database Migration Service automatically provisions a new destination instance using configuration options you select, and migrates the source schemas and data. |
| Migrate to an existing destination instance | Scenarios where target instance parameters must be pre-configured, or when using custom private IP configurations or Terraform-managed instances. | Migrate data into a Cloud SQL instance that you have already created and configured. The destination instance must be empty. |
| Use quick-start migrations (Preview) | Rapid setup and streamlined migrations with pgnative replication
and Private Service Connect network attachments to simplify network configuration. |
Perform an automated migration using predefined configurations and private connectivity to migrate your PostgreSQL databases to Cloud SQL. Learn more in About quick-start migrations. |