You can follow the general procedure in this topic to create and manage a task in data synchronization mode.
- Use cases
The data synchronization mode of DTS replicates ongoing changes between two data stores. This mode is typically used for OLTP-to-OLAP replications and disaster recovery-related replications.
- Supported sources and targets
For more information about supported data sources and targets, see Data synchronization.
- Data type conversion
Different database engines use different sets of data types. You can check the data type conversion that DTS applies between the source and target databases during initial schema synchronization. You can review the data conversions listed in this topic and evaluate the impact of data type conversion on your applications.
- Advanced features
For information about the features of a data synchronization task, see Data synchronization mode.
Data synchronization procedure
You can complete the following higher level steps to create and manage a data synchronization task.
|1. Set up the networking environment||
Before you use DTS for data synchronization, prepare the environments that are required for the source and target databases.
For more information, see Set up a network environment for replication.
|2. Create a data synchronization instance and task||Create a data synchronization task in the DTS console. For detailed, step-by-step procedures about specific synchronization scenarios, see Data synchronization procedure list.|
|3. Monitor the performance of the synchronization task and manage objects||
View the performance metrics of the task. For more information, see Check the synchronization performance.
|4. Stop the data synchronization task||Stop the data synchronization task if you no longer need the task. For more information, see Stop a data synchronization task|