This topic describes the application scenarios, limitations, and procedure for DDL synchronization when you create a data migration or synchronization project.
Application scenarios
When you create a data migration or synchronization project, you can choose whether to enable DDL synchronization. DDL operations, such as CREATE TABLE, ALTER TABLE, DROP TABLE, and TRUNCATE TABLE, are synchronized to the destination only after you enable DDL synchronization. The DDL synchronization feature applies to long-term data migration and synchronization projects to significantly lower the O&M costs.
Limitations
Not all DDL operations are supported for synchronization.
If a table to be synchronized involves unsupported DDL operations, the data migration or synchronization project may be interrupted and unrecoverable data exceptions may arise.
Do not perform DDL operations for database or table schema changes in the schema migration/synchronization or full migration/synchronization phase. Otherwise, the data migration or synchronization project may be interrupted.
Procedure
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.
On the Select Migration Type or Select Synchronization Type page, select Incremental Synchronization and then DDL Synchronization.
Complete subsequent project settings as prompted.