This topic describes the conversion scope and incompatibilities of DDL synchronization during data migration from a MySQL database to a MySQL tenant of OceanBase Database.
Supported DDL operations
CREATE TABLE: For more information, see CREATE TABLE.ALTER TABLE: For more information, see ALTER TABLE.TRUNCATE TABLE: For more information, see TRUNCATE TABLE.RENAME TABLE: For more information, see RENAME TABLE.DROP TABLE: For more information, see DROP TABLE.CREATE INDEX: For more information, see CREATE INDEX.DROP INDEX: For more information, see DROP INDEX.
Unsupported operations
CREATE/DROP/ALTER DATABASE
CREATE/DROP/ALTER FUNCTION
CREATE/DROP/ALTER PROCEDURE
CREATE/DROP/ALTER EVENT
CREATE / DROP / ALTER VIEW
CREATE/DROP/ALTER ROLE
CREATE / DROP / ALTER TRIGGER
CREATE/DROP/ALTER USER
CREATE/DROP/ALTER SERVER
CREATE/DROP/ALTER TABLESPACE
Operations other than those listed in the "Supported operations" section of this topic are not supported.
Incompatibilities
For more information, see DDL incompatibilities between a MySQL database and a MySQL tenant of OceanBase Database.