Specify DDL Comparison at Daemon Level | Teradata Data Mover - Setting DDL Comparison at the Daemon Level - 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

Use the compare_ddl element in the job creation XML to specify that DDL comparison be performed for the individual object, for all tables and views in a database, or for all tables and views in the job.

The compare_ddl flag is always optional at the object, database or job level; you do not need to explicitly set a value. By default, DDL comparison is enabled when you specify an individual table or view to be copied, and disabled for tables and views when copying an entire database.

  1. Run the list_configuration command.
    The command writes its output to a configuration XML file (by default: ./configuration.xml)
  2. Open the configuration XML file.
  3. For the key daemon.default.compareDDL.enabled under the property element, specify the desired value:
    Option Description
    true Perform DDL comparison for all of the tables and views copied using this daemon.
    false Do not perform DDL comparison for all of the tables and views copied using this daemon.
    unspecified Default
Daemon level example: Enabling DDL comparison for all tables and views copied using that daemon.
<property>
  <key>daemon.default.compareDDL.enabled</key>
  <value>true</value>
  <description>Purpose: Enable/Disable the default compareDDL behavior at the daemon level. Default value unspecified.</description>
</property>