Compare and synchronize constraints in SQL Server databases

Constraints
Parameters of comparison and synchronization for Constraints in SQL Server databases, including comparison by definition for Primary and Foreign Keys, Default, Check and Unique constraints

Common parameters

Strict constraint naming

If this option is not set, the comparison algorithm will ignore the names of constraints and provide a comparison according to their definitions only. Use this option to align the names of constraints too.

NOCHECK

Use the option "NOCHECK" to create Primary Keys, Foreign Keys, Check Constraints, Unique Constraints.

Primary Keys

Compare and synchronize Primary Keys.

Create

Create new ones, if they are not defined for the table of the target database.

Rebuild

Rebuild (drop and create) existing ones to remove the differences.

Drop

Drop existing ones, if they are not defined for the table of the template database. Removal will not take place, if the table does not exist in the template database.

Foreign Keys

Compare and synchronize Foreign Keys.

Create

Create new ones, if they are not defined for the table of the target database.

Rebuild

Rebuild (drop and create) existing ones to remove the differences.

Drop

Drop existing ones, if they are not defined for the table of the template database. Removal will not take place, if the table does not exist in the template database.

Drop duplicates

Drop the duplicate constraints based on their definitions.

Default Constraints

Compare and synchronize Default Constraints.

Create

Create new ones, if they are not defined for the table of the target database.

Rebuild

Rebuild (drop and create) existing ones to remove the differences.

Drop

Drop existing ones, if they are not defined for the table of the template database. Removal will not take place, if the table does not exist in the template database.

Check Constraints

Compare and synchronize Check Constraints.

Create

Create new ones, if they are not defined for the table of the target database.

Rebuild

Rebuild (drop and create) existing ones to remove the differences.

Drop

Drop existing ones, if they are not defined for the table of the template database. There is no drop performed if the table does not exist in the template database.

Drop duplicates

Drop the duplicate constraints based on their definitions.

Unique Constraints

Compare and synchronize Unique Constraints.

Create

Create new ones, if they are not defined for the table of the target database.

Rebuild

Rebuild (drop and create) existing ones to remove the differences.

Drop

Drop existing ones, if they are not defined for the table of the template database. Removal will not take place, if the table does not exist in the template database.

Drop duplicates

Drop the duplicate constraints based on their definitions.