Compare SQL Server schemas and deploy differences

Try SQL Compare free for 14 days

Introduction to SQL Compare

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

71% of the Fortune 100 use SQL Compare – because it's relentlessly tested, easy to use, fast, and saves time.

You can work with live databases, database snapshots, SQL scripts in source control, or backups. SQL Compare helps you compare and deploy changes quickly, simply and with zero errors.

Pricing information

Standard edition

per user

Buy now

Key features

Do all this with SQL Compare Standard

  • Save time comparing and synchronizing SQL Server database schemas
  • Eliminate mistakes migrating database changes from dev, to test, to production
  • Speed up the deployment of new SQL Server schema updates
  • Generate T-SQL scripts that update one SQL Server database to match the schema of another
  • Find and fix errors caused by differences between databases
  • Compare and synchronize from within SQL Server Management Studio
  • Deploy to SQL Server databases, SQL Azure databases, or SQL Server on Amazon RDS

Do even more with SQL Compare Pro

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)
Compare and deploy changes to SQL Server database schemas
Compare, synchronize, and deploy database schemas from within SSMS
Automatically create error-free deployment scripts
Save deployment scripts for later use
Automatically create error-free synchronization scripts
Comparison and synchronization of large databases
Migrate individual schema differences, a selection of them, or all of them
Build sophisticated rules to selectively limit what to synchronize
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 prior to synchronizing
Save schema snapshots for audit and roll-back purposes
Create reports in HTML or Excel detailing database differences
Command line automation
(If you're using the command line on a build server, you'll need the DLM Automation Suite)
Use fast deployment to bypass the comparison results and manually 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 object SQL scripts
Restore just a single object (or selection of objects) from a backup file

Display full feature list

A clear path through database deployment

SQL Source Control and SQL Compare Pro now work together to help you rationalize database deployment without sacrificing control over the change process.

Control how changes are handled

SQL Source Control connects your databases to your existing version control system, making it simple to share development work within SQL Server Management Studio.

When it comes to complex database changes, such as table or column splits, SQL Source Control lets you provide reusable scripts that specify exactly how your changes should be handled.

Your scripts are stored in source control alongside the objects they modify and are applied whenever someone accepts your updates.

Repeatable, reliable deployments

Because your changes are stored in a single, central location, with instructions on how to apply them, any team member can deploy, confident that changes will work as intended and that your data will stay safe.

Deploy from source control

When you're ready to deploy, SQL Compare Pro detects your development changes, along with any scripts that specify how to deploy them.

With source control and manual deployments in place, you also have the groundwork to automate your deployments. To take the next steps, try the DLM Automation Suite, which lets you automate database deployments with your release management tool.


Select what you want to compare
Select what you want to compare
Select objects to deploy
Select objects to deploy
Create a deployment script
Create a manual deployment script
Compare and deploy within SSMS
Compare and deploy manually from within SSMS

What our customers are saying

DLM: Manual

One of Redgate’s Database Lifecycle Management tools

Want to improve how your organization develops databases? SQL Compare makes manual deployments quicker and safer, so it’s a great first step. If you want to save even more time and reduce risk further, visit our DLM pages to see how else Redgate can help.

For more process and business benefits, visit our DLM overview.