All Products
Document Center

Data Management:Overview of data synchronization solutions

Last Updated:Jan 17, 2024

Data Transmission Service (DTS) allows you to synchronize data between data sources in real time. Typical scenarios include active geo-redundancy, geo-disaster recovery, zone-disaster recovery, cross-border data synchronization, cloud business intelligence (BI) systems, and real-time data warehousing. This topic describes the database types, synchronization types, and synchronization topologies that are supported by DTS to synchronize data.

Billing rules

You are charged for using the data synchronization feature of Data Transmission Service (DTS). For more information about the billing rules,see Billing overview.

Synchronization types

Synchronization typeDescription
Schema synchronization

DTS synchronizes the schemas of required objects from the source database to the destination database. Tables, views, triggers, and stored procedures can be synchronized.

Note Before you configure a data synchronization task, check whether schema synchronization is supported. If schema synchronization is not supported, you must create a destination database and tables based on the schemas of required objects in the source database.
Full data synchronization

DTS synchronizes the historical data of required objects from the source database to the destination database. Historical data is the basis for subsequent incremental synchronization.

To simplify data synchronization, we recommend that you select both Schema Synchronization and Full Data Synchronization when you configure a data synchronization task.

Incremental data synchronizationBy default, incremental data synchronization is supported. DTS synchronizes incremental data that are generated in the source database to the destination database in real time.

Synchronization topologies

For information about the synchronization topologies, see Synchronization topologies.

Data synchronization scenarios

DTS supports the following data synchronization scenarios. You can select one of the following scenarios based on your business requirements to view the supported database versions, synchronization types, and configuration procedure.