Compare and synchronize CLR objects in SQL Server databases

CLR
Parameters of comparison and synchronization for CLR objects in SQL Server databases, including comparing of definitions for Assemblies, CLR Stored Procedures, CLR Functions, CLR Aggregates and CLR Triggers

Assemblies

Compare and synchronize Assemblies & Assembly Files.

Apply TRUSTWORTHY ON

Turn on TRUSTWORTHY on the target database, if there are assemblies to synchronize that are authorized for UNSAFE or EXTERNAL_ACCESS.

Create

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

Alter

Alter existing ones to remove the differences.

Drop

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

CLR Stored Procedures

Compare and synchronize CLR 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.

CLR Scalar-Valued Functions

Compare and synchronize CLR 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.

CLR Table-Valued Functions

Compare and synchronize CLR 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.

CLR Aggregates

Compare and synchronize CLR Aggregates.

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.

CLR Triggers

Compare and synchronize CLR 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. There is no drop performed if the table does not exist in the template 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.

CLR Types

Compare and synchronize CLR Types.

Create

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

Drop

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