Compare and synchronize stored procedures, functions and triggers in SQL Server databases

Programmability
Parameters of comparison and synchronization for Programmability in SQL Server databases: Stored Procedures, Scalar-Valued and Table-Valued Functions, Table and View Triggers

Common parameters

ANSI_NULLS

If this option is not set, the comparison algorithm will ignore the ANSI_NULLS property for the objects. It is highly recommended to always use this option in the comparison.

Stored Procedures

Compare and synchronize Stored Procedures.

Create

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

Rebuild

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

Drop

Drop existing ones, if they do not exist in the template 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.

Rebuild

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

Drop

Drop existing ones, if they do not exist in the template 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.

Rebuild

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

Drop

Drop existing ones, if they do not exist in the template 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.

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.

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.

Rebuild

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

Drop

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

Recreate all

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