Enable Compare DDL for all Tables | Teradata Data Mover - Enabling Compare DDL for All Tables - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.20
Published
November 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
wph1512683331242.ditamap
dita:ditavalPath
4101_UG_dm_1620.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
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.
  1. Add the compare_ddl element.
  2. 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>
</database>