Compare and synchronize constraints and indexes of SQL Server databases

Settings for comparing and synchronizing Constraints and Indexes of SQL Server databases

Common parameters

Strict constraint naming

Set this option to change constraint names. Otherwise, the comparison algorithm will not recreate identical by definition but different by name constraints.

NOCHECK

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

SORT_IN_TEMPDB

Use the SORT_IN_TEMPDB = ON option to perform operations on key-constraints and indexes whenever possible.

ONLINE

Use the ONLINE = ON option to perform operations on tables, key-constraints, and indexes whenever possible.

MAXDOP

Use the MAXDOP option to perform operations on tables, key-constraints, and indexes whenever possible.

PAD_INDEX

Set this option to change the PAD_INDEX property of objects. Otherwise, the comparison algorithm will try to inherit these values ​​from existing objects.

FILLFACTOR

Set this option to change the FILLFACTOR property of objects. Otherwise, the comparison algorithm will try to inherit these values ​​from existing objects.

IGNORE_DUP_KEY

Set this option to change the IGNORE_DUP_KEY property of objects. Otherwise, the comparison algorithm will try to inherit these values ​​from existing objects.

STATISTICS_INCREMENTAL

Set this option to change the STATISTICS_INCREMENTAL property of objects. Otherwise, the comparison algorithm will try to inherit these values ​​from existing objects.

STATISTICS_NORECOMPUTE

Set this option to change the STATISTICS_NORECOMPUTE property of objects. Otherwise, the comparison algorithm will try to inherit these values ​​from existing objects.

ALLOW_ROW_LOCKS

Set this option to change the ALLOW_ROW_LOCKS property of objects. Otherwise, the comparison algorithm will try to inherit these values ​​from existing objects.

ALLOW_PAGE_LOCKS

Set this option to change the ALLOW_PAGE_LOCKS property of objects. Otherwise, the comparison algorithm will try to inherit these values ​​from existing objects.

OPTIMIZE_FOR_SEQUENTIAL_KEY

Set this option to change the OPTIMIZE_FOR_SEQUENTIAL_KEY property of objects. Otherwise, the comparison algorithm will try to inherit these values ​​from existing objects.

BUCKET_COUNT

Set this option to change the BUCKET_COUNT property of objects. Otherwise, the comparison algorithm will try to inherit these values ​​from existing objects.

COMPRESSION_DELAY

Set this option to change the COMPRESSION_DELAY property of objects. Otherwise, the comparison algorithm will try to inherit these values ​​from existing objects.

Primary Keys

Compare and synchronize Primary Keys.

Create

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

Alter

Alter existing ones to remove the differences.

Recreate

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

Drop

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

Unique Constraints

Compare and synchronize Unique Constraints.

Create

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

Alter

Alter existing ones to remove the differences.

Recreate

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

Drop

Drop existing ones, if they are not defined for the table of the source database. Removal will not take place, if the table does not exist in the source 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.

Recreate

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

Drop

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

Check Constraints

Compare and synchronize Check Constraints.

Create

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

Recreate

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

Drop

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

Drop duplicates

Drop the duplicate constraints based on their definitions.

Foreign Keys

Compare and synchronize Foreign Keys.

Create

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

Recreate

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

Drop

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

Drop duplicates

Drop the duplicate constraints based on their definitions.

Table Indexes

Compare and synchronize Table Indexes.

Create

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

Alter

Alter existing ones to remove the differences.

Recreate

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

Drop

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

Drop duplicates

Drop the duplicate constraints based on their definitions.

View Indexes

Compare and synchronize View Indexes.

Create

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

Alter

Alter existing ones to remove the differences.

Recreate

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

Drop

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

Drop duplicates

Drop the duplicate constraints based on their definitions.

XML Indexes

Compare and synchronize XML Indexes.

Create

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

Alter

Alter existing ones to remove the differences.

Recreate

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

Drop

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

Drop duplicates

Drop the duplicate constraints based on their definitions.