Compare and Sync
SQL Server Schemas

dbForge Schema Compare for SQL Server is a reliable database comparison tool that saves you time and effort when comparing and synchronizing SQL Server databases. This tool allows you to work with live SQL Server databases, snapshots, script folders, and native backups. You can quickly compare your SQL Server databases, analyze differences and perform error-free schema synchronization using generated SQL scripts. The tool integrates with SQL Server Management Studio.

Compare live databases, SQL Server native backups or script folders
Sync staging or production databases with development databases
Generate concise and accurate database deployment T-SQL scripts
Restore functions and procedures from SQL Server native backups
Automate routine synchronization tasks with command-line interface
Deploy to SQL Server, SQL Azure, and SQL Server on Amazon RDS
Export schema comparison results to HTML, Excel, and XML

Features

Schema Comparison Result Analysis

Filter, group, and sort objects in results
View DDL differences for each object pair
Preview the schema update script for each object
Generate a schema comparison report in Excel and HTML formats

dbForge Schema Compare for SQL Server - Comparison Result Analysis

Supported Data

You can use the following objects as Source and Target for schema comparison and synchronization:

SQL Server database schemas
SQL Azure Cloud objects
Script folders
Database Snapshots
Custom mapped tables
SQL Server installed on Linux
SQL Server native backups

dbForge Schema Compare for SQL Server - Supported Data

Supported Schema Objects

When you compare SQL databases in Schema Compare, the following schema objects are supported:

Application Role
Assembly
Asymmetric Key
Broker Priority
Certificate
Contract
DDL Trigger
Default
Event Notification
Symmetric Key
Full Text Catalog
Full Text Stoplist

Function
Message Type
Partition Function
Partition Scheme
Procedure
Queue
Sequence
Role
Route
Rule
Schema

...and much more!

dbForge Schema Compare for SQL Server - Supported schema objects

Scripts folder and version control integration

Compare objects in scripts folders committed to the source control system
Support for Team Foundation Server (TFS), Subversion (SVN), Git and Github version control systems
Compare objects in different revisions, including the head revision
Create schema snapshots for audit and roll-back purposes

dbForge Schema Compare for SQL Server - Version control integration

Synchronization features

The synchronization functionality of Schema Compare provides the following options and abilities:

Generate deployment scripts for review or synchronization purposes
Migrate any schema differences (individual, selected, or all)
Dependency check to script objects in the correct order for updates
Automatic resolution of synchronization issues
Warnings on controversial points prior to synchronization

dbForge Schema Compare for SQL Server - Synchronization features

Non-Schema Object Comparison

In addition to database schema synchronization, you can synchronize the following types of objects using Schema Compare:

Database properties
Extended object properties
Per-object security permissions

dbForge Schema Compare for SQL Server - Non-schema object synchronization

T-SQL Code Comparison

dbForge Schema Compare for SQL Server allows you to efficiently compare T-SQL code with the following options:

Ignore white spaces and comments in code
Ignore differences in identifier and keyword case
Decrypt and compare encrypted objects

dbForge Schema Compare for SQL Server - T-SQL code comparison

Routine Task Automation

Completing routine tasks becomes easier and more convenient with Schema Compare's automation capabilities:

Save comparison project settings for future use
Utilize the tool's internal script generation feature to get a PowerShell automation script
Use the script in a .bat file and schedule its execution via the Windows Scheduler, automating the schema synchronization process

dbForge Schema Compare for SQL Server - Routine task automation

Export Comparison Reports

When the comparison process is finished, you can easily export schema comparison reports directly from Schema Compare.

Include actual data into the report
Select the objects that need to be exported
You can export the data in HTML, Excel and XML formats

dbForge Schema Compare for SQL Server - Export comparison reports

SSMS Integration

Schema Compare can be easily integrated with SQL Server Management Studio to be used internally from this IDE for schema comparison and synchronization purposes.

I feel I made a very good decision in buying different products from Devart. Products like Schema Compare for SQL Server, SQL Complete and Code Compare are excellent products.