Page History

...

• Drop and Recreate Foreign Keys indicates that all foreign keys are dropped prior to applying changes during the resolution process. This option should be used with Wrap Statements in Transaction to ensure that foreign keys do not remain dropped in the event that the synchronization script used to resolve it fails.
  If this option is not selected, a data comparison job generates ordered table insert and delete statements, and you must do the following tasks:
  • In the Mapping page, select all dependent tables. If a referenced table is missing from the comparison, DB Change Manager cannot ensure the referential integrity of the data.

  • If you also change the comparison key, you must set the same column as a comparison key for all dependent tables. If you do not do so, DB Change Manager cannot insure the referential integrity of the data.

    NOTE:

    Info
    This option is only available for SQL Server scripts.

• Wrap Statements in a Transaction utilizes a transaction and rolls back any repository changes if it encounters an error.

  NOTE:

  Info
  This option is not supported for DB2 for LUW scripts.

• Enable Identity Column Inserts and Updates enables changes to identity column values on SQL Server and Sybase platforms. The update and insert statements are automatically included in the synchronization script when this option is selected.

CM/Data > Data Result Options

The Data Result Options affect how data comparison results are processed:

• Cache options. The Comparison Result Cache Location specifies the directory path of the result cache, where job data is captured. Use the Default Location, or de-select it, and then browse to a new directory location.

  Info
  This is a temporary cache. Large data comparison jobs may require many system resources.

• Refresh Interval. The Data Movement Progress Refresh Interval determines how quickly the progress of the data comparison is updated, in seconds.

CM/Data > General

The General options relate to data mapping:

• Remembered dialog decisions. When you select a default masking rule on a database or table, this option affects the masking rule used on the corresponding tables or columns. Yes means the rule is used on all. No means the tables or columns use the rule set explicitly for them. The default Prompt allows you to make the decision at the time you select the masking rule on the database or table.
• Don’t show again decisions. When the Automatically Synchronize option is toggled, some mappings become invalid and are removed. If you want to see this information, select this box.

CM/Data > Mapping Validation

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.

CM/Data > Script Generation

...