Using Google Cloud SQL for SQL Server as a target
This section describes how to set up and use a Cloud SQL for SQL Server database as a target in a replication task.
When configuring a task with a Google Cloud SQL for SQL Server target endpoint, note the following:
-
If the Apply Changes task option is enabled and the change processing mode is set to Batch optimized apply, it is recommended to enable the Apply batched changes to multiple tables concurrently option in the Change Processing Tuning tab.
-
When the Apply batched changes to multiple tables concurrently option is selected, the option to set a Global Error Handling policy will not be available. Also, some of the task-specific error handling defaults will be different.
For more information, see the Apply batched changes to multiple tables concurrently option in the Change Processing Tuning tab.