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.
- Run the list_configuration command.The command writes its output to a configuration XML file (by default: ./configuration.xml)
- Open the configuration XML file.
- 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>