We're having some problems with our phones at the moment. You can reach us at +44 (0)800 014 7384 if you have any questions.

Compare SQL Server schemas and deploy differences fast

  • Save time comparing and deploying SQL Server database schemas
  • Create error-free deployment scripts in minutes
  • Find and fix errors caused by differences between databases
Try SQL Compare free for 14 days

SQL Compare Demo in 30 Seconds

Introduction to SQL Compare

SQL Compare is the industry standard for comparing and deploying SQL Server database schemas quickly and accurately.

71% of the Fortune 100 use SQL Compare to compare SQL Server databases – because it's relentlessly tested, easy to use, creates flawless deployment scripts, and saves time.

Whether you need to deploy changes or explore the differences between two SQL Server databases, SQL Compare helps you do the job quickly, simply, and with zero errors.

I bless the day we bought SQL Compare - it saves me time so often. Must have paid for itself a hundred times over.

Bill Geake, Senior Systems Analyst, Phillip Securities Pte Ltd

Pricing information

Standard edition

$495
per user

Limited to manual diffs and synching of databases

Buy now

Pro edition

$745
per user

Includes command line support and deployment from source control and backups

Buy now

SQL Compare is part of the SQL Toolbelt

Sync data, deploy from version control, & more, with all our SQL Server tools

See what’s included
Select the objects you want to deploy in the SQL Compare UI, and inspect line-level T-SQL differences between them

Make deployments faster

Remembering the changes you’ve made to a database, working out what your colleagues have done, and scripting it out for deployment is tricky and time consuming.

SQL Compare makes it fast.

You can explore what’s changed in each database object, down to individual lines of SQL. When you’re ready to deploy, you can create an error-free deployment script in minutes.

Deploy with zero errors

SQL Compare scripts dependencies in your database in the right order, to make sure deployment is successful.

It also flags up any issues, such as data loss, before you deploy.

Warnings about any problems with deployment are highlighted for you in the SQL Compare UI through the Review Deployment Script screen
Compare any combination of SQL Server databases, backups, snapshots, or source control repositories

Find and fix problems in production

To fix errors in your production database, compare it to a backup, scripts in source control, or a database snapshot. You can deploy single objects to fix the issue fast.

If you need to fix static data, use SQL Data Compare to deploy changes without the need for full database recovery.

Deploy with scripts, the UI, or the command line

SQL Compare fits into the development process you prefer.

You can automate deployments with the command line, run them from the UI, or save a deployment script and run it yourself.

For review and sign-off, you can also export a list of changes in HTML or Excel formats.

Deploy from the UI, or copy SQL Compare's deployment script and run it yourself in SQL Server Management Studio

What our customers are saying

Full list of features

What can I compare, synchronize, and deploy?StandardPro
SQL Server 2005, 2008, 2012, 2014, SQL Azure, & SQL Server on Amazon RDS databases
Snapshots of the schema
Backup files (both native SQL Server & Redgate SQL Backup Pro)
Folders of SQL scripts (for source control)
FeaturesStandardPro
Compare and deploy changes to SQL Server database schemas (from dev, to test, to production)
Compare two SQL Server databases, synchronize, and deploy from within SSMS
Automatically create error-free deployment scripts
Generate T-SQL scripts that update one SQL Server database to match the schema of another
Save deployment scripts for later use
Automatically create error-free synchronization scripts
Comparison and deployment of large databases
Migrate individual schema differences, a selection of them, or all of them
Build sophisticated rules to selectively limit what to deploy
Deploy individual schema differences, a selection of them, or all of them
Support for reading encrypted database objects
Fine-grained filtering of database objects
Troubleshoot database differences
Dependency checking, so objects are scripted in the correct order for updates
Warnings about anything you need to be aware of before deploying SQL Server schemas
Save schema snapshots for audit and roll-back purposes
Create reports in HTML or Excel detailing database differences
Troubleshoot database differences and explore schema changes to see what's going on in development
Command line automation
(If you're using the command line on a build server, you'll need DLM Automation)
Use fast deployment to bypass the comparison results and deploy database schemas from the Project Configuration dialog box
Automatically output a database into individual object creation scripts
Deploy a live database from a set of SQL object scripts
Restore just a single object (or selection of objects) from a backup file
Get alerts when SQL Server databases drift using DLM Dashboard
Compare and sync SQL Server static data as part of your database deployment with SQL Data Compare