This topic describes the scenarios, limitations, and procedure of using DML filtering when you create a data migration or synchronization project.
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
Configure a data migration or synchronization project to the Select Migration Type or Select Synchronization Type step.
For more information, see the topics for data migration or data synchronization projects of the corresponding type.
On the Select Migration Type or Select Synchronization Type page, select Incremental Synchronization.
DML Synchronization is selected by default. You need to select the DML statements to be synchronized.
Complete subsequent project settings as prompted.