This topic describes the scenarios, limitations, and procedure of enabling DDL synchronization when you create a data migration or synchronization project.
Scenarios
When you create a data migration or synchronization project, you can specify whether to synchronize DDL operations. DDL operations such as CREATE, ALTER, DROP, and TRUNCATE TABLE will be synchronized to the destination database only after DDL synchronization is enabled. The DDL synchronization feature applies to long-term data migration and synchronization projects to significantly lower the O&M costs.
Limitations
Only DDL operations that are explicitly listed in the documentation are supported.
If a table to synchronize involves unsupported DDL operations, the relevant data migration or synchronization project may be interrupted, which causes unrecoverable data inconsistencies.
Do not perform DDL operations for database or schema changes during schema migration, schema synchronization, full migration, or full synchronization. Otherwise, the data relevant project may be interrupted.
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 and then DDL Synchronization.
Complete subsequent settings of the project based on related topics.