Data Transmission Service (DTS) data synchronization workflow - Data Transmission Service

Data Synchronization enables real-time sync across data sources for active geo-redundancy, geo-disaster recovery, local data disaster recovery, cross-border sync, query and report offloading, Cloud BI, and real-time data warehousing.

Overview

Synchronization solution overview

Lists supported databases, synchronization types, topologies, and configuration guides.
Data type mapping during schema initialization

DTS maps source data types to compatible destination types during schema initialization. Review these mappings to assess the impact on your business.
Key capabilities

All capabilities are covered in Data Synchronization.

Process

Data synchronization involves the following steps.

Procedure	Description
Prerequisites	Configure network connectivity and security settings (such as IP whitelisting) so that DTS can access the source and destination databases.
Configure a synchronization task	Configure the synchronization task in the Console.
Manage the synchronization task	Monitor the task performance The performance monitoring feature tracks task status and provides management insights. Modify the synchronized objects Add or remove synchronization objects while the task runs. Configure alert monitoring Set alerting rules for key metrics to get real-time task status updates.
Release a synchronization task	Release the task when it is no longer needed.