Data Transmission Service (DTS) continuously syncs data between databases so you always have an up-to-date copy at the destination. This topic walks you through the full configuration process in the old DTS console.
For an overview of how to create, monitor, and manage synchronization tasks, see Manage a data synchronization task.
The steps in this topic apply to most data synchronization scenarios. For source-specific configuration details, see Overview of data synchronization scenarios.
Prerequisites
Before you begin, ensure that you have:
-
A purchased data synchronization instance that matches the database type and region of your source and destination databases. For details, see Purchase a DTS instance
-
(If your source is a self-managed MySQL database or a PolarDB for MySQL cluster) Binary logging enabled. See Enable binary logging and Create an account for a self-managed MySQL database and configure binary logging
Configure a synchronization task
-
Log on to the DTS console.
If you are redirected to the Data Management (DMS) console, click the
icon in the 
to switch to the old DTS console. -
In the left-side navigation pane, click Data Synchronization.
-
At the top of the Synchronization Tasks page, select the region where your data synchronization instance resides.
-
Find your data synchronization instance and click Configure Synchronization Channel in the Actions column.
-
Configure the source and destination instances, then click Set Whitelist and Next in the lower-right corner.
If the source or destination is an Alibaba Cloud database instance, DTS automatically adds the CIDR blocks of DTS servers to the instance's whitelist. This allows DTS servers to connect to the database instance.
-
Select the synchronization policy and the objects to be synchronized, then click Next
Setting Description Select the objects to be synchronized In the Available section, select one or more tables or databases and click the 
icon to move them to the Selected section. If you select a database, all schema changes in that database are synced to the destination. By default, object names remain unchanged after synchronization. To rename objects at the destination, use the Rename Databases and Tables setting below.Rename Databases and Tables Use the object name mapping feature to rename objects in the destination instance. For details, see Object name mapping. Replicate Temporary Tables When DMS Performs DDL Operations Controls whether DTS syncs temporary tables created by online DDL operations in DMS. Select Yes to sync temporary table data — note that large DDL operations may cause sync delays. Select No to sync only the original DDL statements — note that destination tables may be locked during DDL operations. Retry Time for Failed Connections How long DTS retries if it loses the connection to the source or destination database. The default is 720 minutes (12 hours). If DTS reconnects within this window, the task resumes automatically. Charges apply while DTS is retrying, so set this based on your business needs and release the DTS instance promptly when it is no longer needed. -
Select the initial synchronization types, then click Precheck in the lower-right corner.
-
After the precheck completes, review the results. DTS runs a precheck before starting the task. If any item fails:
-
Click the
icon next to the failed item to see details. -
Fix the reported issues and click Precheck again, or ignore failed items and rerun the precheck.
-
-
After the precheck dialog displays The precheck is passed., close the dialog. The data synchronization task starts automatically.
-
On the Synchronization Tasks page, wait until the task status changes to Synchronizing.
