Data Transmission Service:Modify the objects to be synchronized

Prerequisites

• The data synchronization task starts to write incremental data. The task is in the Running state or fails to synchronize data.

• The source and destination databases are not in the process of upgrade, configuration change, network switchover, or cross-zone migration when you modify the objects to be synchronized. 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.

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

Notes

• If a data synchronization task has an Incremental Write module that is not running, you cannot modify the objects to be synchronized for the task.

• If you add fields to a data synchronization task, the full data of the fields is not synchronized to the destination database. However, the incremental data of the fields is synchronized to the destination database.

• If you modify the Synchronization Types parameter when you add an object to a task, the modification takes effect only for the added object.

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

• You cannot modify the objects other than databases and tables when you modify the object to be synchronized.

• You cannot modify the Whether to Migrate Accounts parameter when you modify the object to be synchronized.

• If the destination database is an AnalyticDB for MySQL V2.0 cluster, you must perform the related operations in the DTS console of the previous version.

  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 you select tables as the objects to be synchronized, do not perform DDL operations within 5 minutes before you modify the objects to be synchronized. Otherwise, the DTS task fails.

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

• If you do not configure an independent conflict resolution policy for a two-way synchronization instance, you cannot configure such a policy when you modify the object to be synchronized.

• If you need to add and remove the object to be synchronized, we recommend that you perform these operations in two steps. For example, you can remove an object to be synchronized and save this operation first, and then add a new object to be synchronized. Otherwise, an error occurred 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 instance 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. Find the data synchronization task that you want to manage and click Reselect Objects in the Actions column.

3. Modify the objects to be synchronized.

   • Add an object to the data synchronization task

     In the Source Objects section, select the object that you want to add and click the icon to move the object to the Selected Objects section.

     Important

     • You can configure the Synchronization Types parameter to select whether to synchronize the schema and full data of the added object. If you modify the Synchronization Types parameter, the modification takes effect only for the added object.

     • If you use only the object name mapping feature, you must move the object to be synchronized from the Selected Objects section to the Source Objects section and save the modification. After that, add the object to be synchronized to the Selected Objects section. Then, you can use the object name mapping feature. Otherwise, the feature does not take effect.

   • Remove an object from the data synchronization task

     In the Selected Objects section, select the object that you want to remove and click the icon to move the object to the Source Objects section.

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 based on your business requirements and run a precheck again.

6. Wait until the success rate becomes 100%, and click Changed. Return .Success Rate.

7. In the Status column, view the status of the task after the objects to be synchronized are modified.

   Note

   If the Auto Refresh feature is disabled, manually click the icon above the Actions column to refresh the Status. of the synchronization task.

FAQ

• Can I modify the Kafka Data Compression Format parameter when I need to synchronize data to a Kafka cluster?

  Yes, it is supported.

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

  No, it is not supported.