Data synchronization procedure of Data Transmission Service (DTS) - Data Transmission Service

The data synchronization feature synchronizes data between data sources in real time. This feature supports various business scenarios, such as active geo-redundancy, geo-disaster recovery, local data disaster recovery, cross-border data synchronization, query and report offloading, cloud business intelligence (BI), and real-time data warehousing. This topic describes how to use the data synchronization feature to create, monitor, and manage data synchronization tasks.

Background information

Overview of data synchronization solutions
This topic describes the databases, initial synchronization types, and synchronization topologies that are supported by the data synchronization feature. It also describes the configuration steps.
n">This topic describes the databases, initial synchronization types, and synchronization topologies that are supported by the data synchronization feature. It also describes the configuration steps.
Data type mappings for initial schema synchronization
Different databases support different data types, which cannot always be perfectly mapped. During an initial schema synchronization, DTS maps data types based on the types supported by the destination database. Review these mappings to assess the impact on your business.
rent data types, which cannot always be perfectly mapped. During an initial schema synchronization, DTS maps data types based on the types supported by the destination database. Review these mappings to assess the impact on your business.
Features
For more information, see Data synchronization.
5ff4f82f09ufs">Data synchronization.

Data synchronization procedure

To perform data synchronization using Data Transmission Service (DTS), follow these steps.

Procedure	Description
Preparations ions	Before using DTS for data synchronization, prepare the source and destination databases to meet the environment requirements.
Configure a synchronization task nchronization task	Complete the synchronization task configuration with simple operations in the console.
Manage the synchronization task synchronization task	Monitor task performance The replication performance display feature lets you monitor the status of data synchronization tasks and provides a basis for task management. " props="intl">replication performance display feature lets you monitor the status of data synchronization tasks and provides a basis for task management. Modify synchronization objects During the data synchronization process, you can add or remove synchronization objects. xv">During the data synchronization process, you can add or remove synchronization objects. Configure monitoring and alerting Configure alert rules for important metrics to be notified of the task status promptly. gure alert rules for important metrics to be notified of the task status promptly.
End the synchronization task onization task	If you no longer need data synchronization, end the synchronization task.