Data Transmission Service:Modify the objects to be synchronized

Prerequisites

• The data synchronization instance is in the Incremental Write phase, and its status is Running or 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 switches, or cross-zone migrations when you modify the objects to be synchronized. The source and destination databases must be in a normal operational state.

• The latency of the data synchronization task 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 to a data synchronization task, the full data of the fields will not be synchronized to the destination database. However, the incremental data of the fields will be synchronized to the destination database.

• 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, which may cause a latency of several minutes in the synchronization task.

• You cannot add or modify a data verification task when you modify the objects to be synchronized.

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

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

• If your destination database is AnalyticDB for MySQL 2.0, you must perform this operations in the previous version of the console.

  Note

  You can move the pointer over the 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 objects to be synchronized. Otherwise, the synchronization task will report an error.

• If the source database is a SQL Server database, you cannot add or remove the database when you modify the objects to be synchronized.

• If you do not configure an independent conflict resolution policy for a bidirectional synchronization instance, you cannot set one when you modify the objects to be synchronized.

• If you need to both add and remove synchronization objects, perform these operations in two separate steps. For example, first remove the objects and save the change, then proceed to add a new object. 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. Click Reselect Objects in the Actions column of the target data synchronization instance.

3. Modify the objects to be synchronized.

   • 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 of the added objects. This selection applies only to the added objects.

     • If you want to use only the object name mapping feature, you must move the objects to be synchronized from the Selected Objects section to the Source Objects section and submit the modification. After that, add the objects back to the Selected Objects section. You can then use the object name mapping feature. Otherwise, the feature will not take effect.

   • Remove synchronization objects

     In the Selected Objects box, select the object that you want to remove, and then click the icon 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 objects to be synchronized, the task runs a precheck. You can start the data synchronization task only after the task passes the precheck.

   • If the precheck fails or a warning occurs, fix the issue as needed and run a precheck again.

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

7. In the Status column, view the status of the instance after the synchronization objects are modified.

   Note

   If you have not enabled the Auto Refresh feature, you need to manually click the 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?

  Yes, it is supported.

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

  Yes, it is supported.

• Can I modify a data verification task when I modify the objects to be synchronized?

  No, it is not supported.