Compare and synchronize stored procedures, functions, triggers, and user types of SQL Server databases

Settings for comparing and synchronizing Stored Procedures, Scalar-Valued and Table-Valued Functions, Table and View Triggers of two SQL Server databases

Common parameters

ANSI_NULLS

If this option is not set, the comparison algorithm will ignore the ANSI_NULLS property of the objects when comparing, however, if the object is re-created due to other differences, the new value will be taken.

Stored Procedures

Compare and synchronize Stored Procedures.

Create

Create new ones, if they do not exist in the target database.

Recreate

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

Drop

Drop existing ones, if they do not exist in the source database.

Recreate All

Recreate all objects of a given type in the target database.

Scalar-Valued Functions

Compare and synchronize Scalar-Valued Functions.

Create

Create new ones, if they do not exist in the target database.

Recreate

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

Drop

Drop existing ones, if they do not exist in the source database.

Recreate All

Recreate all objects of a given type in the target database.

Table-Valued Functions

Compare and synchronize Table-Valued Functions.

Create

Create new ones, if they do not exist in the target database.

Recreate

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

Drop

Drop existing ones, if they do not exist in the source database.

Recreate All

Recreate all objects of a given type in the target database.

Table Triggers

Compare and synchronize Table Triggers.

Create

Create new ones, if they do not exist in 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.

Recreate All

Recreate all objects of a given type in the target database.

View Triggers

Compare and synchronize View Triggers.

Create

Create new ones, if they do not exist in 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 view of the source database. Removal will not take place, if the view does not exist in the source database.

Recreate All

Recreate all objects of a given type in the target database.

Types

User Data Types

Compare and synchronize User Data Types.

Create

Create new ones, if they do not exist in the target database.

User Table Types

Compare and synchronize User Table Data Types.

Create

Create new ones, if they do not exist in the target database.