DML filtering

This topic describes the application scenarios, limitations, and procedure for DML filtering when you create a data migration or synchronization project.

Application scenarios

When you create a data migration or synchronization project, you can set a synchronization strategy for the DML statements to be synchronized. Only statements that meet the specified conditions are synchronized to the destination. DML filtering applies to scenarios of migrating historical tables and transaction details tables.

Limitations

• DML filtering applies to INSERT, DELETE, and UPDATE operations.

• DML filtering takes effect on the entire data migration or synchronization project.

• Full data verification is not supported for a data migration project for which DML filtering is configured.

Procedure

1. Configure the data migration or synchronization project to the Select Migration Type or Select Synchronization Type step.

   For more information, see the documentation of data migration or data synchronization projects of the corresponding type.

2. On the Select Migration Type or Select Synchronization Type page, select Incremental Synchronization.

3. DML Synchronization is selected by default. You need to select the DML statements to be synchronized.

4. Complete subsequent project settings as prompted.