All Products
Search

This Product

    Data Transmission Service:Modify synchronization objects

    Document Center

    Data Transmission Service:Modify synchronization objects

    Last Updated:Jan 07, 2026

    Data Transmission Service (DTS) lets you add or remove synchronization objects from a running data synchronization instance without reconfiguring it. This feature helps you modify synchronization objects with minimal impact on your business.

    Prerequisites

    • The data synchronization instance is in the Incremental Write phase and has a status of Running or Synchronization Failed.

    • To ensure that DTS can connect to the databases and read the schema information, do not perform operations such as upgrades, configuration changes, network transitions, or cross-zone migrations while you modify the synchronization objects. The source and destination databases must be running normally.

    • The latency of the data synchronization instance is less than 10 minutes.

    Notes

    • If an instance has an Incremental Write module that is not running, you cannot modify the synchronization objects.

    • If you add fields as synchronization objects, the full data for those fields is not synchronized to the destination database. However, the incremental data for the fields is synchronized.

    • If you modify the Synchronization Types when adding new synchronization objects, the change applies only to the newly added objects.

    • After you add a synchronization object, DTS restarts the Incremental Data Collection module. This may cause a latency of several minutes in the sync task.

    • You cannot add or modify a data validation task while you modify the synchronization objects.

    • You cannot modify objects other than databases and tables during this process.

    • You cannot modify the Whether to Migrate Accounts setting while you modify synchronization objects.

    • If your destination database is AnalyticDB for MySQL 2.0, you must use the previous version of the console.

      Note

      You can move the pointer over the jiqiren image in the lower-right corner of the DMS console and click the 返回旧版 icon to go to the DTS console of the previous version.

    • If your synchronization objects are at the table level, do not perform DDL operations within 5 minutes before you modify the synchronization objects. Otherwise, the sync task may report an error.

    • If the source database is a SQL Server database, you cannot add or remove databases while you modify the synchronization objects.

    • If you do not configure an independent conflict resolution policy for a two-way synchronization instance, you cannot set one while you modify the synchronization objects.

    • To both add and remove synchronization objects, perform these operations in two separate steps. For example, first remove the objects and submit the change, and then add the new objects. Otherwise, an error may occur in the synchronization instance.

    Procedure

    1. Use one of the following methods to go to the Data Synchronization page and select the region in which the data synchronization instance resides.

      DTS console

      1. Log on to the DTS console.

      2. In the left-side navigation pane, click Data Synchronization.

      3. In the upper-left corner of the page, select the region in which the data synchronization task resides.

      DMS console

      Note

      The actual operations may vary based on the mode and layout of the DMS console. For more information, see Simple mode and Customize the layout and style of the DMS console.

      1. Log on to the DMS console.

      2. In the top navigation bar, move the pointer over Data + AI and choose DTS (DTS) > Data Synchronization.

      3. From the drop-down list to the right of Data Synchronization Tasks, select the region in which the data synchronization instance resides.

    2. In the Actions column of the target data synchronization instance, click Reselect Objects.

    3. Modify the synchronization objects.

      • Add synchronization objects

        In the Source Objects box, select the object that you want to add, and then click 向右 to move it to the Selected Objects box.

        Important

        • In the Synchronization Types section, you can select whether to synchronize the table schema and full data for the added objects. This selection applies only to the added objects.

        • If you want to use only the object name mapping feature, you must first move the synchronization objects from the Selected Objects box to the Source Objects box and submit the change. Then, add them back to the Selected Objects box. After you complete these steps, the object name mapping feature will take effect.

      • Remove synchronization objects

        In the Selected Objects box, select the object that you want to remove, and then click 左移 to move it to the Source Objects box.

    4. Click Next: Advanced Settings.

    5. Click Next: Precheck and Start Task.

      Note

      • After you modify the synchronization objects, DTS runs a precheck. You can start the synchronization job only after the instance passes this precheck.

      • If the precheck fails or a warning is reported, resolve the issue and run the precheck again.

    6. When the Success Rate is 100%, click Changed. Return .

    7. In the Status column, view the status of the instance after you modify the synchronization objects.

      Note

      If you have not enabled the Auto Refresh feature, you must manually click the Refresh icon above the Actions column to refresh the Status of the synchronization instance.

    FAQ

    • Can I modify the Kafka Data Compression Format for a data synchronization instance with Kafka as the destination?

      It is supported.

    • Can I modify the Message acknowledgement mechanism for a data synchronization instance with Kafka as the destination?

      This is supported.

    • Can I modify a data validation task when I modify the synchronization objects?

      Not supported.

    • The precheck fails after I add a synchronization object. How do I delete the added object?

      1. Log on to the Data Transmission Service (DTS) console.

      2. In the task list, find the target task and click the task ID.

      3. In the navigation pane on the left, click Synchronization Object Modification Records. On the Added Synchronization Object Records tab, find the corresponding subtask and click End Task and Roll Back Synchronization Object Modification.

    • A DTS task is configured for full and incremental synchronization. How do I perform a full resynchronization for a specific object?

      1. Remove the synchronization object:

        1. In the Actions column of the target data synchronization instance, click Reselect Objects.

        2. In the Selected Objects box, select the object that you want to remove, and then click 左移 to move it to the Source Objects box.

        3. Click Next: Advanced Settings and Next: Precheck and Start Task.

        4. When the precheck success rate is 100%, click Changed. Return .

      2. Add the synchronization object back:

        Note

        Before you add the synchronization object back, delete the object from the destination database to prevent data inconsistency.

        1. In the Actions column of the target data synchronization instance, click Reselect Objects.

        2. In the Source Objects box, select the object that you want to add, and then click 向右 to move it to the Selected Objects box.

        3. Click Next: Advanced Settings and Next: Precheck and Start Task.

        4. When the precheck success rate is 100%, click Changed. Return .