Compare and synchronize CLR objects of SQL Server databases

Comparison and synchronization settings for Assemblies, CLR Stored Procedures, CLR Functions, CLR Aggregates, CLR Triggers, and CLR Data Types of two SQL Server databases

Assemblies

Compare and synchronize Assemblies.

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 source database.

Assembly Files

Compare and synchronize Assembly Files.

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.

CLR Stored Procedures

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

CLR Scalar-Valued Functions

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

CLR Table-Valued Functions

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

CLR Aggregates

Compare and synchronize CLR Aggregates.

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.

CLR Triggers

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

Recreate All

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

Types

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 source database.