DDL statements supported by AWS DMS - AWS Database Migration Service

DDL statements supported by AWS DMS

You can execute data definition language (DDL) statements on the source database during the data migration process. These statements are replicated to the target database by the replication server.

Supported DDL statements include the following:

  • Create table

  • Drop table

  • Rename table

  • Truncate table

  • Add column

  • Drop column

  • Rename column

  • Change column data type

DMS doesn’t capture all supported DDL statements for some source engine types. And DMS handles DDL statements differently when applying them to specific target engines. For information about which DDL statements are supported for a specific source, and how they’re applied to a target, see the specific documentation topic for that source and target endpoint.

You can use task settings to configure the way DMS handles DDL behavior during change data capture (CDC). For more information, see Task settings for change processing DDL handling.