Page History

...

DB Change Manager performs a variety of validation checks when it compares or synchronizes data. You can specify severity responses for mapping validation checks on comparison and synchronization jobs. By default, some checks always indicate an error. For other checks, you can configure the response.

Image Added

• Ignore means that there is no indication regarding that specific validation check.
• Warning means that a warning message indicating that there is a problem with the mapping validation is issued.
• Error means that an error message indicating that there is a problem with the mapping validation is issued.

Once you configure the responses, click Apply.

CM/Data > Script Generation

Script Generation Options affect how DB Change Manager builds a synchronization script for a data comparison job. These options are useful if the match key for a table in a data comparison job does not reflect uniqueness. For example, if a match is performed on last_name, and there are several values of “Smith” in a table, the data synchronization may have unexpected results.

• Warn about duplicate rows. By default, DB Change Manager issues a warning whenever it encounters duplicate rows while generating a synchronization script.
• Exclude duplicate rows. If you want to automatically ignore duplicate rows while generating a synchronization script, select this option.
• Set quoted identifier ON/OFF. For SQL Server and Sybase only, if the quoted identifier database option is off, this option prefixes the data synchronization script with SET QUOTED IDENTIFIER ON and suffixes it with SET QUOTED IDENTIFIER OFF.

Once you configure the responses, click Apply.

CM/Schema > Archive Options

...