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, and backups. You can quickly compare your SQL Server databases, analyze differences and perform error-free schema synchronization using generated SQL scripts.

Compare live databases, backups or script folders
Sync staging or production databases with development databases
Generate database synchronization SQL scripts
Restore functions and procedures from 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

Supported Data Supported Schema Objects Schema Snapshots and Version Control Integration Comparison Result Analysis Synchronization Features Non-Schema Object Synchronization T-SQL Code Comparison Script Generation Routine Task Automation SSMS Integration

Supported Data

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

SQL Server database schemas
Snapshots of schemas
SQL Server 2005 - 2016 backup files
Custom mapped tables

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
External Data Source
Full Text Catalog
Full Text Stoplist

Function
Message Type
Partition Function
Partition Scheme
Procedure
Queue
Remote Service Binding
Role
Route
Rule
Schema

Search Property List
Security Policies
Sequence
Service
Symmetric Key
Synonym
Table
User
User Defined Type
View
XML Schema Collection

Schema snapshots and version control integration

Create schema snapshots for audit and roll-back purposes
Automatically commit snapshots to a version control system
Compare previous versions of a schema with the current one (integration with Team Foundation Server and Subversion supported)

dbForge Schema Compare for SQL Server - Version control integration

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

Synchronization features

Schema Compare can act as a powerful SQL server synchronization tool. The synchronization functionality of Schema Compare provides the following options and abilities:

Create accurate synchronization scripts
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 Synchronization

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

Script Generation

dbForge Schema Compare allows you to generate scripts to compare SQL Server schemas. The following options are available in Schema Compare script generation:

Schema Export (Generate Script Wizard)
Schema-only backups in addition to full backups
Large database support
Generate Script projects to save settings for future use
Zip compression for export files
Command line support for scheduling schema export tasks
Error and status logging

dbForge Schema Compare for SQL Server - Script generation

Routine Task Automation

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

Save comparison project settings for future use
Use the command line interface for automatic routine synchronizations

dbForge Schema Compare for SQL Server - Routine task automation

SSMS Integration

Schema Compare can be easily integrated with SSMS 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.