The data synchronization mode of Data Transmission Service (DTS) replicates ongoing changes between two data stores. This mode is typically used for OLTP-to-OLAP replications and disaster recovery-related replications.
Objects that can be replicated include databases, tables, and columns. You can specify objects that you want to replicate.
|Reselect objects to be synchronized||You can add and remove objects to be synchronized while a data synchronization task is running.|
|Track synchronization performance||You can check the performance of a data synchronization task while it is running.||Check the synchronization performance|
Data synchronization task lifecycle
To fulfill a data replication process in any of the three modes, you must create a data replication task. A data replication task holds all the configurations of the replication process, such as the source database, target database, and objects to be replicated.
The following table describes the statuses of a synchronization task.
|Task status||Description||Applicable operations|
|Prechecking||A precheck is being performed and the synchronization task has not started.||
|Precheck Failed||The synchronization task failed to pass the precheck.||
|Not Started||The synchronization task has passed the precheck but is not started.||
|Performing Initial Synchronization||The initial synchronization is in progress.||
|Initial Synchronization Failed||Data replication has failed during initial synchronization.||
|Synchronizing||The task is replicating data.||
|Synchronization Failed||An error occurred during synchronization.||
|Paused||The synchronization task is paused.||
A synchronization task in the Synchronization Failed or Initial Synchronization Failed status will be automatically retried multiple times within seven days of the failure occurring. To discard the data synchronization, you must manually pause or stop the synchronization task.