Migration preferences for Microsoft SQL Server

This page describes the available migration preferences for Microsoft SQL Server database deployments.

Cloud SQL for SQL Server settings

Migration Center lets you choose Cloud SQL as the target database deployment for your database.

  • From the MS SQL version type list, select the version type to which you want to migrate.
  • From the Sizing method list, select the sizing strategy that you want to apply during the migration. If you select Utilization based, Migration Center uses performance metrics from your database, if available, to provide sizing recommendations.

Availability

Specify how to distribute your database across Google Cloud zones.

  • From the Zones list, select either Single zone or Multiple zones. Choosing multiple zones for your database provides a backup zone in case the primary zone becomes unavailable.

For more information about region-specific considerations, see Geography and regions.

Multithreading

By default, multithreading is enabled on Cloud SQL databases. To save on costs, you can choose to disable simultaneous multithreading. This might reduce the performance of your database.

For more information, see Simultaneous multithreading.

Automatic backup

Specify if you want to enable automatic backups.

For more information, see About Cloud SQL backup.

Pricing track

Specify your preferred pricing track for the database that you migrate to Google Cloud.

Choose between on demand pricing, or a committed use of one or three years. Committed use discounts (CUDs) apply when you choose a committed use, and appear in your total cost of ownership (TCO) report.

For more information, see Cloud SQL pricing.

What's next