Compare SQL Server Schemas

dbForge Schema Compare for SQL Server is a reliable database schema comparison tool that saves you time and effort when comparing and synchronizing SQL Server databases. SQL Compare allows you to work with live SQL Server databases, snapshots, script folders, and native backups.

You can compare your SQL Server databases, analyze differences, and perform error-free schema synchronization using generated SQL scripts. Besides, you can automate schema synchronization using the internal feature. The SQL diff tool integrates with SQL Server Management Studio.

Compare live databases, SQL Server native backups or script folders

The tool enables you to specify a database, backup, script folder, source control version, or snapshot as Source and Target for comparison.

Sync staging or production databases with development databases

Smart Schema Synchronization Wizard provides broad options to set up and customize the synchronization process.

Generate concise and accurate database deployment T-SQL scripts

You can generate an error-free database synchronization script and execute it
without reviewing or edit the script in the internal editor.

Restore functions and procedures from SQL Server native backups

The tool supports a wide selection of schema objects, such as sequences, rules, functions, procedures, etc., that can be synchronized and restored from backup.

Automate routine synchronization tasks with command-line interface

Using the Schema Compare tool, you can generate a PowerShell automation script and schedule its execution via Windows Scheduler.

Deploy to SQL Server, SQL Azure, and SQL Server on Amazon RDS

Benefit from the broad compatibility options of the Schema Compare tool as it supports such cloud services as Amazon RDS and SQL Azure.

Export schema comparison results to HTML, Excel, and XML

The tool's functionality allows saving the comparison results in the form of a report, which can be easily customized and saved in three different file formats.

Set up database development with Continuous Integration

Implement database CI process with Schema Compare: deploy a database from a script folder, introduce changes to the schema, and deliver seamless updates.

Schema Compare Killer feature

Well-Designed Interactive HTML Objects Diff Report

Generate an interactive HTML comparison result report
Navigate through a read-only HTML report
Keep track of the changes applied
Make an analysis of DDL differences between objects
View a deployment script

Explore how to easily generate an interactive HTML comparison report.

Features

Schema Comparison Result Analysis

Filter, group, and sort objects in results
View DDL differences for each object pair with word wrap, view white spaces, show line numbers, view hex, show columns and constraints alphabetically, format database object script options
View the text comparer in the detached window on a different screen
Select an individual object, a group of objects, or all objects for synchronization
Change the type of an operation for synchronization to None or Drop
Preview the schema update deployment script for each object

dbForge Schema Compare for SQL Server - Comparison Result Analysis

Export Comparison Report

Handy Generate Comparison Report wizard allows setting up and generating reports on the comparison results in three file formats:

HTML - a Hypertext Markup Language file format is perfect for publishing the report in the web. HTML reports also allow presenting script diffs in a report as:
- Removed-added lines
- Crossed out words
Excel - one of the most popular spreadsheet file formats
XML - an extensible markup language file format used to share the data on the World Wide Web

Supported Data Sources

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

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

dbForge Schema Compare for SQL Server - Supported Data

Supported Schema Objects

Wth Schema Compare, you can apply the Object Filter feature and compare the following schema objects:

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 script folders committed to the source control system
Support for Team Foundation Server (TFVS), Subversion (SVN), Git, Github, and Azure DevOps version control systems
Compare objects in different revisions, including the head revision
Create schema snapshots for audit and roll-back purposes

SQL Compare - 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 sync issues ensures error-free script deployment
Warnings on controversial points prior to deployment

dbForge Schema Compare for SQL Server - Synchronization features

Non-Schema Object Comparison

In addition to database schema sync, you can synchronize the following types of objects using this database diff tool:

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 the code of stored routines
Ignore differences in identifier, keyword case, and reduction
Decrypt and compare encrypted objects

Database diff tool 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 and task automation
Use the tool's internal script generation feature to get a PowerShell script
Use the script in a .bat file and schedule its execution via the Windows Scheduler, automating schema synchronization
Set up Continuous Integration (CI) and Continuous Delivery (CD) with dbForge DevOps Automation for SQL Server

dbForge Schema Compare for SQL Server - Routine task automation

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.

Set a database as source or target
Set a scripts folder as source or target
Set source control as source or target

dbForge Schema Compare for SQL Server - SSMS Integration

Leading companies
choose dbForge Schema Compare

What people say

Leave a testimonial

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.

SUNIL

Really awesome product - got company to purchase a licence :) Keep up the great work!

Mike Bowering

Kcom

Success Stories from our customers

"It does the comparison with the click of a button... We have had NO bugs released to production as a result of an incorrect schema."

James Spruill

Company Owner

Read full story

Get started with dbForge Schema Compare at no cost

Download a FREE 30-day trial and start saving time spent on your routine database operations today.

Download for free

Buy multiple licenses with a substantial discount

We provide flexible purchase options, including bulk discounts, to meet the budget of each and every customer.

Purchase now

Try SQL Tools with Schema Compare included

Sync schemas, deploy from version control, write SQL, and more with our mega pack of SQL Server tools.

Find out more

Schema Compare as part of DevOps Automation

Use Schema Compare along with dbForge DevOps Automation for SQL Server to extend the DevOps approach to SQL Server databases. The solution makes it easy to integrate SQL Server database into the DevOps process without compromising quality, performance, or reliability.

Explore