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
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-06-16
dita:mapPath
fcu1619423186706.ditamap
dita:ditavalPath
mpm1591127278842.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>