Configure your source Cloud SQL for SQL Server instance

This page describes how to configure a Cloud SQL for SQL Server source for for continuous homogeneous SQL Server migrations.

In this migration path, Database Migration Service automatically handles all the required backup file exports to a Cloud Storage bucket when you migrate between two Cloud SQL for SQL Server instances.

To prepare your Cloud SQL for SQL Server instance for a homogeneous migration with Database Migration Service, do the following:

1. Create a dedicated migration user account in your instance. See Create a user in the Cloud SQL documentation.
2. Assign the necessary privileges to the dedicated migration user account. Run the following commands:

   SQL Server 2019 and earlier

   For SQL Server 2019 and earlier versions, grant the VIEW SERVER STATE permission.

   USE [master];
   GO
   
   GRANT VIEW SERVER STATE TO MIGRATION_USER;
   GO

   Replace MIGRATION_USER with the name of the migration user account.

   SQL Server 2022 and later

   For SQL Server 2022 and later versions, grant the VIEW SERVER STATE permission.

   USE [master];
   GO
   
   GRANT VIEW SERVER PERFORMANCE STATE TO MIGRATION_USER;
   GO

   Replace MIGRATION_USER with the name of the migration user account.

3. Enable point-in-time recovery (PITR) on your source instance.

What's next

Continue with your migration. See Migration guide for Cloud SQL for SQL Server sources.