Specify DDL Comparison at Daemon Level | Teradata Data Mover - 17.10 - Setting DDL Comparison at the Daemon Level - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)

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>