Known limitations

Preview — Database Migration Service for homogeneous SQL Server migrations

This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

Database Migration Service migrates all data from the backup files you upload to the Cloud Storage bucket, but not all features present in your source database might be available in Cloud SQL for SQL Server. Database Migration Service migration jobs don't restore data that falls under an unsupported feature, but your destination Cloud SQL for SQL Server instance might produce warnings or errors in the logs.

Before you choose to migrate your SQL Server databases to Cloud SQL for SQL Server, make sure you consider SQL Server features unavailable for Cloud SQL in Cloud SQL for SQL Server documentation.

Note: You can also use Google Cloud Migration Center to discover possible limitations or gaps in feature support for your specific scenario. See Discover and import databases in the Migration Center documentation.

Additional known limitations for homogeneous SQL Server migrations to Cloud SQL for SQL Server with Database Migration Service include the following:

• Database Migration Service can migrate up to a maximum of 20 databases per migration job.

• You can run only one migration job for a single destination Cloud SQL for SQL Server instance.

• Database Migration Service supports only full backups and transaction log backups. Other backup types aren't supported.

• Your backup files can have a maximum size of 5 TB.

• You can stripe your full backup file into smaller files if your database size exceeds 5 TB. Each stripe can have a maximum size of 5 TB.

• Your source SQL Server instance can't use the simple recovery model. For more information on recovery models, see See Recovery Models (SQL Server) in Microsoft documentation.

• Database Migration Service doesn't migrate the SQL Server master database, user information (such as user logins), or jobs that aren't a part of a specific database.

  • Point-in-time recovery (PITR) can't be enabled on your destination Cloud SQL instance during migration. You can enable this feature after the migration is complete.