Create and configure the Cloud SQL for SQL Server destination instance

For homogeneous SQL Server migrations to Cloud SQL, Database Migration Service requires that you first create and configure your Cloud SQL destination instance. Perform the following steps:

  1. Create your destination instance. Make sure you use enough compute and memory resources to cover your migration needs and follow the requirements listed in known limitations.

  2. Create and configure a dedicated migration user in your destination Cloud SQL instance. This user is required for Database Migration Service to successfully connect to your destination instance and monitor your data. You need to provide the username and password for this account at a later stage, when you create the destination connection profile.

    1. Create the database user account in your destination Cloud SQL for SQL Server instance. See Create and manage users in the Cloud SQL documentation.

    2. Assign the following privileges to the user account:

      • For SQL Server 2019: VIEW ANY DEFINITION and VIEW SERVER STATE
      • For later versions: VIEW ANY DEFINITION and VIEW SERVER PERFORMANCE STATE

    For information on how to assign privileges to user accounts, see Changing permissions for users in the Cloud SQL documentation.

  3. Grant the Cloud Storage permissions to the service account associated with your destination instance. This account is created after you create the destination instance.

    1. Check the email address associated with this service account on the Cloud SQL instance detail page. See View instance information in the Cloud SQL documentation.

    2. Add the storage.objects.get, and storage.objects.list permissions to the service account. For information on how to manage access with Identity and Access Management, see Manage access to projects, folders, and organizations in the IAM documentation.

What's next?