This page describes how to migrate your self-managed or Amazon RDS
SQL Server databases to a Cloud SQL for SQL Server instance by using
backup and transaction log files uploaded to Cloud Storage.
For instructions on how to migrate from a Cloud SQL for SQL Server source, see
[Migration guide for Cloud SQL for SQL Server sources](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/csql-sql-server-src-guide.md.txt).

> [!NOTE]
> **Note:** For instructions on how to migrate directly over a private network connection without exporting backup files, see [Migrate from self-managed SQL Server using
> Distributed Availability Groups](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/dag-migration-guide).

The migration process involves the following tasks:

1. Exporting full database backup, and transaction
   log files from the source SQL Server instance.

   You can also use the optional differential database backup in your migration
   process.
2. Uploading your backup files to a Cloud Storage bucket.

3. Creating the destination Cloud SQL for SQL Server instance.

4. Creating and running the migration job in Database Migration Service.

5. Monitoring the migration job progress with Database Migration Service observability
   features.

6. Promoting the migration job after the data is fully migrated.

## Costs

For homogenous migrations to Cloud SQL, Database Migration Service is offered
at no additional charge. However, Cloud SQL and Cloud Storage pricing
applies for network charges as well as Cloud SQL and Cloud Storage
entities created for migration purposes.

In this document, you use the following billable components of
Google Cloud:

- Cloud Storage
- Cloud SQL

To generate a cost estimate based on your projected usage, use the
[pricing calculator](https://docs-0cloud-0google-0com.linkedin.net.nz/products/calculator).

## Before you begin

1. Verify if this migration path can fully support your scenario. See [SQL Server
   Known limitations](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/known-limitations).
2. Consider in which region you want to create the destination database. Database Migration Service is a fully-regional product, meaning all entities related to your migration (source and destination connection profiles, migration jobs, destination databases, storage buckets) must be saved in a single region.
3. In the Google Cloud console, on the project selector page, select or [create a Google Cloud project](https://docs-0cloud-0google-0com.linkedin.net.nz/resource-manager/docs/creating-managing-projects.md.txt).

   [Go to project selector](https://console-0cloud-0google-0com.linkedin.net.nz/projectselector2/home/dashboard)
4. Enable the Database Migration Service, Compute Engine, Cloud Storage, and Cloud SQL Admin APIs. [Enable the APIs](https://console-0cloud-0google-0com.linkedin.net.nz/apis/enableflow?apiid=compute.googleapis.com,datamigration.googleapis.com,sqladmin.googleapis.com,storage.googleapis.com)

### Required roles

To get the permissions that you need to perform homogeneous SQL Server
migrations with Database Migration Service, ask your administrator to grant the
required IAM roles on your project for the following
[accounts involved in the migration process](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/access-control.md.txt)

- User account that performs the migration:
  - [Database Migration Admin](https://docs-0cloud-0google-0com.linkedin.net.nz/iam/docs/roles-permissions/datamigration.md.txt#datamigration.admin) (`roles/datamigration.admin`)
  - [Storage Admin](https://docs-0cloud-0google-0com.linkedin.net.nz/iam/docs/roles-permissions/storage.md.txt#storage.admin) (`roles/storage.admin`)
  - [Cloud SQL Editor](https://docs-0cloud-0google-0com.linkedin.net.nz/iam/docs/roles-permissions/cloudsql.md.txt#cloudsql.editor) (`roles/cloudsql.editor`)
- Database Migration Service service account:
  - [Database Migration Admin](https://docs-0cloud-0google-0com.linkedin.net.nz/iam/docs/roles-permissions/datamigration.md.txt#datamigration.admin) (`roles/datamigration.admin`)
  - [Storage Admin](https://docs-0cloud-0google-0com.linkedin.net.nz/iam/docs/roles-permissions/storage.md.txt#storage.admin) (`roles/storage.admin`)
  - [Cloud SQL Editor](https://docs-0cloud-0google-0com.linkedin.net.nz/iam/docs/roles-permissions/cloudsql.md.txt#cloudsql.editor) (`roles/cloudsql.editor`)
  - [Cloud SQL Studio User](https://docs-0cloud-0google-0com.linkedin.net.nz/iam/docs/roles-permissions/cloudsql.md.txt#cloudsql.studioUser) (`roles/cloudsql.studioUser`)

For more information about granting roles, see
[Manage access](https://docs-0cloud-0google-0com.linkedin.net.nz/iam/docs/granting-changing-revoking-access.md.txt).

These predefined roles contain the permissions required to perform homogeneous
SQL Server migrations with Database Migration Service. To see the exact permissions
that are required, expand the **Required permissions** section:

#### Required permissions

The following permissions are required to perform homogeneous SQL Server
migrations with Database Migration Service:

- User account that performs the migration:
  - `datamigration.* `
  - `resourcemanager.projects.get`
  - `resourcemanager.projects.list`
  - `cloudsql.operations.get`
  - `cloudsql.instances.create`
  - `cloudsql.instances.get`
  - `cloudsql.instances.list`
  - `cloudsql.instances.import`
  - `cloudsql.databases.get`
  - `cloudsql.databases.list`
  - `cloudsql.databases.delete`
  - `compute.machineTypes.list`
  - `compute.machineTypes.get`
  - `compute.projects.get`
  - `storage.buckets.create`
  - `storage.buckets.list`
- Database Migration Service service account:
  - `datamigration.* `
  - `resourcemanager.projects.get`
  - `resourcemanager.projects.list`
  - `cloudsql.instances.create`
  - `cloudsql.instances.get`
  - `cloudsql.instances.list`
  - `cloudsql.instances.executeSql`
  - `storage.objects.create`
  - `storage.objects.list`

You might also be able to get these permissions with
[custom roles](https://docs-0cloud-0google-0com.linkedin.net.nz/iam/docs/creating-custom-roles.md.txt) or other
[predefined roles](https://docs-0cloud-0google-0com.linkedin.net.nz/iam/docs/roles-permissions.md.txt).

## Prepare your source data

To prepare your source data for migration, follow these steps:

1. [Consider your backup strategy for the migration process](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/supported-backup-files.md.txt).
   Database Migration Service supports using a differential backup and the transaction log
   files for migrating data that appears in your database after you take the full
   backup.

2. [Perform a full backup of your source SQL Server database](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/export-backup-files.md.txt).
   Make sure you use the correct naming pattern.

3. [Prepare a Cloud Storage bucket and upload your backup files to it](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/storage-buckets.md.txt).
   Make sure you set up the necessary directory structure for each backup file type
   you want to use.

4. [Create a source connection profile](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/create-source-connection-profile.md.txt) for the Cloud Storage bucket.

## Prepare your Cloud SQL for SQL Server destination instance

To configure your destination Cloud SQL instance, perform the following steps:

1. [Create and configure your Cloud SQL for SQL Server destination instance](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/create-cloud-sql-destination-instance.md.txt).
   Make sure you use enough compute and memory resources to cover your migration needs,
   and assign the Storage Admin (`roles/storage.admin`) role to the instance's
   service account.

2. [Create a destination
   connection profile](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/create-destination-connection-profile) for your Cloud SQL instance.

## Create and run the migration job

To configure and run your migration, perform the following steps:

1. [Create and run the migration job](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/create-migration-job.md.txt).

   When you start the migration job, your destination Cloud SQL for SQL Server
   databases are put into recovery mode where they are fully managed by
   Database Migration Service. You can promote your destination instance
   when your data is fully migrated. After your destination instance is promoted,
   all the databases in that instance become fully operational. You also gain
   full write access to those databases.

   > [!NOTE]
   > **Note:** To you use a differential backup file in the migration process, you need to use a specific configuration when you create the migration job. You can upload the differential backup file at a later time- after you create the migration job, but before you start uploading transaction log files.

   You can monitor the migration progress, as well as your destination instance
   health with Database Migration Service observability
   features. See
   [Migration job metrics](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/migration-job-metrics.md.txt).
2. Keep uploading new transaction log backup files to the Cloud Storage bucket.

   To cover data that appears in your source database after you perform
   the full backup export,
   [export transaction log backup files](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/export-backup-files.md.txt) and upload them to
   the storage bucket. Database Migration Service automatically detects new files,
   reads their contents, and pushes the data to your destination instance.
   See
   [Automate transaction log exports](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/automate-backup-exports.md.txt).

## Finalize the migration

When you decide to switch your application to the new Cloud SQL for SQL Server
instance, finalize the migration by following these steps:

1. Stop all write operations on your source databases. You can switch them to read-only mode to retain operational functionality.
2. Take the last transaction log backup, upload the file to your storage bucket, and stop the incremental load phase in Database Migration Service. You can achieve this result by performing one of the following actions:
   - Stop your [automated backup file uploads](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/automate-backup-exports.md.txt), or upload the last transaction log file. Monitor the [unprocessed transaction log backups size](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/migration-job-metrics.md.txt) to determine when Database Migration Service finishes processing that file.
   - Optionally, you can upload a transaction log file whose name ends in `.trn.final` suffix. Database Migration Service stops continuous loads when it detects a backup file whose name matches the [`.trn.final` suffix convention](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/export-backup-files.md.txt).

     When Database Migration Service finishes processing that file, migration
     job status changes to
     [**Ready to promote**](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/migration-job-statuses.md.txt#ready-to-promote).
3. [Promote the migration job](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/finalize-migration.md.txt).
4. (Optional) [Verify migration data](https://docs-0cloud-0google-0com.linkedin.net.nz/database-migration/docs/sqlserver/verify-migration.md.txt) for completeness.