Data Synchronization enables real-time data synchronization across various data sources. It supports business scenarios such as active geo-redundancy, geo-disaster recovery, local data disaster recovery, cross-border data synchronization, query and report offloading, Cloud BI, and real-time data warehousing. This topic describes the process to create, monitor, and manage data synchronization tasks.
Overview
Synchronization solution overview
Describes the databases, synchronization types, and topologies supported by data synchronization, and provides links to relevant configuration guides.
Data type mapping during schema initialization
Because database support for data types varies, a direct one-to-one mapping is not always possible. During schema initialization, DTS maps data types to those compatible with the destination database. You should review these mappings to assess the potential impact on your business.
Key capabilities
For a complete list of capabilities, see Data Synchronization.
Process
Data synchronization using Data Transmission Service (DTS) involves the following steps.
Procedure | Description |
Before initiating data synchronization, configure network connectivity and security settings (e.g., IP whitelisting) to ensure both source and destination databases are accessible to DTS. | |
Configure the synchronization task in the Console. | |
|
|
Release the data synchronization task when it is no longer required. |