Page History
...
| Anchor | ||||
|---|---|---|---|---|
|
The Resolution Options section determines how the job resolves any discrepancies discovered during the comparison process.
- 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: 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: 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
...