You can follow the general procedure in this topic to create and manage a task in data synchronization mode.
Background information
- 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. To check the data type conversion that DTS applies between the source and target databases during initial schema synchronization, see Data type conversion.
- 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.
Step | Description |
---|---|
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 Overview of data synchronization scenarios. |
3. Monitor the performance of the synchronization task and manage objects |
View the performance metrics of the task. For more information, see View the connection status and performance of data synchronization. You can also add objects to or remove objects from the task. For more information, see Add an object to a data synchronization task and Remove an object from a data synchronization task. |
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. |