You can use Data Transmission Service (DTS) to synchronize data between two data sources in real time. The data synchronization feature is ideal for multiple business 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.

Background information

  • Overview of data synchronization scenarios

    This topic describes the database types, initial synchronization types, and synchronization topologies that are supported by DTS. You can learn the procedures for configuring data synchronization tasks from the provided references.

  • Data type mappings for 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.

  • Features

    For more information, see Data synchronization.

Manage a data synchronization task

StepDescription
1. Preparation overviewBefore you use DTS for data synchronization, prepare the environments that are required for the source and destination databases.
2. Configure a data synchronization taskCreate a data synchronization task by completing simple configurations in the DTS console.
3. Manage a data synchronization task (Optional)
4. Stop a data synchronization taskStop the data synchronization task if you no longer need the task.