Although Data Mover does not automatically compare DDL of tables when copying the entire database, you can enable compare DDL for all database tables being completely or partially copied or renamed.
- Add the compare_ddl element.
- Specify true as the element value.
In the following example DDL comparison is performed on all tables in the MyDB database.
<database selection="all"> <name>MyDB</name> <compare_ddl>true</compare_ddl> <table selection="included"> <name>PPIOrders</name> </table> </database>