This topic describes how to remove an object from a data synchronization task in the DTS console.

Prerequisites

  • The data synchronization task is in the Synchronizing, Paused, or Synchronization Failed state.
  • When you modify a data synchronization task, the source and destination databases must be running. The source and destination databases cannot be in the process of upgrade, configuration change, network switchover, or cross-zone migration. This ensures that DTS can read database and table information from the source database and connect to the source and destination databases.

Notes

After an object is removed from the data synchronization task, the incremental data of the object is no longer synchronized to the destination database.

Procedure

  1. Log on to the DTS console.
  2. In the left-side navigation pane, click Data Synchronization.
  3. At the top of the Synchronization Tasks page, select the region where the destination instance resides.Select a region
  4. Find the data synchronization task and choose More > Modify Objects to Synchronize in the Actions column.Modify the objects to be synchronized
  5. In the Selected section, click the object that you want to remove and click the Left arrow icon to move the object to the Available section.Remove an object from a data synchronization task
  6. Click Precheck and Start.
    Note
    • After you modify 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 the precheck, click the Information icon icon next to each failed item to view details. Fix the issues as instructed and run the precheck again.
  7. Start the data synchronization task.