Database Migration Service

Google Cloud Database Migration Service (DMS) is a fully managed service that makes it simple and straightforward to migrate databases to Cloud SQL and AlloyDB with minimal downtime. It supports homogeneous and heterogeneous database migrations.

Supported Migration Paths:

1. MySQL to Cloud SQL for MySQL - On-premises or cloud MySQL to managed Cloud SQL.

2. PostgreSQL to Cloud SQL for PostgreSQL - Any PostgreSQL source to Cloud SQL.

3. SQL Server to Cloud SQL for SQL Server - On-premises SQL Server to managed Cloud SQL.

4. Oracle to AlloyDB / PostgreSQL - Heterogeneous migration with schema conversion.

5. MySQL/PostgreSQL to AlloyDB - Migrate to Google AlloyDB for PostgreSQL.

The below example shows how to create a DMS migration job using the gcloud CLI.

It gives the following output,

Migration job: my-migration-job
State: RUNNING
Type: CONTINUOUS
Phase: CDC (Change Data Capture)
Source: mysql-source (MySQL 8.0)
Destination: cloudsql-dest (Cloud SQL MySQL 8.0)
Lag: 2s

Migration Types:

One-time migration - Migrates existing data in a single operation. Requires downtime during cutover.

Continuous migration - Uses Change Data Capture (CDC) to keep source and destination in sync, enabling near-zero downtime cutover.