You can use Data Transmission Service (DTS) to synchronize data between two data sources in real time. This feature applies to multiple scenarios, such as active geo-redundancy, geo-disaster recovery, zone-disaster recovery, cross-border data synchronization, query load balancing, cloud business intelligence (BI) systems, and real-time data warehousing. This topic describes how to create, monitor, and manage a data synchronization task.
- Database types, initial synchronization types, and synchronization topologies
This topic describes the database types, initial synchronization types, and synchronization topologies that are supported by DTS.
- Data type mappings for initial schema synchronization
The data types of different databases do not have one-to-one correspondence. This topic describes the data type mappings that DTS uses between the source and destination databases during initial schema synchronization. Based on the data type mappings, you can evaluate the impact of data type conversion on your business.
For information about the features of a data synchronization task, Data synchronization.
Manage a data synchronization task
The following figure shows the steps to manage a data synchronization task.
|1. Prepare for data synchronization||Before you use DTS for data synchronization, prepare the environments that are required for the source and destination databases.|
|2. Create a data synchronization task||Create a data synchronization task by completing simple configurations in the DTS console.|
|3. (Optional) Manage the data synchronization task when it is running||
|4. Stop the data synchronization task||Stop the data synchronization task if you no longer need the task.|