When a data synchronization task is running, you can add objects to the task or remove objects from the task. You do not need to configure the task again. This topic describes how to add an object to a data synchronization task.
Prerequisites
- The data synchronization task is in the Synchronizing or Synchronization Failed state.
- The source and destination databases are not in the process of upgrade, configuration change, network switchover, or cross-zone migration. This ensures that DTS can connect to the source and destination databases. This also ensures that DTS can read database and table information from the source database.
Precautions
The time when DTS synchronizes data of a new object depends on whether initial synchronization is configured for the data synchronization task.
- If initial synchronization is not configured, DTS synchronizes data after incremental data is generated on the source instance.
- If initial synchronization is configured, DTS synchronizes schemas and historical data, and then synchronizes incremental data.
Procedure
- Log on to the DTS console.
- In the left-side navigation pane, click Data Synchronization.
- At the top of the Synchronization Tasks page, select the region where the data synchronization instance resides.
- Find the data synchronization task and choose in the Actions column.
- In the Available section, click the object that you want to add, and click the
icon to move the object to the Selected section.
- Click Precheck. Note
- After you reselect the objects to be synchronized, DTS performs a precheck on the data synchronization task. The data synchronization task can be started only after it passes the precheck.
- If the task fails to pass the precheck, click the
icon next to each failed item to view details. Troubleshoot the issues based on the causes and run a precheck again.
- Start the data synchronization task.