All Products
Search

This Product

    Data Management:Overview of data synchronization solutions

    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.