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 quickly and accurately.

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

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

Pricing information

Standard edition

per user

Limited to manual diffs and synching of databases

Buy now

Pro edition

per user

Includes command line support for automated deployments and schema change monitoring

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
  • Explore schema changes to see what's going on in development
  • 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
  • Compare and sync your static data with SQL Data Compare

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 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


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 deployment script
Compare and deploy within SSMS
Compare and deploy from within SSMS

What our customers are saying

Sync schemas and data with the SQL Developer Suite

The SQL Developer Suite contains nine of Redgate's industry-standard tools, including SQL Compare Pro and its sister product SQL Data Compare Pro, which compares, syncs, and deploys your data.

Alongside our comparison tools, you get SQL Prompt, SQL Source Control, and five other products that speed up and simplify SQL Server development.

To see how they can make your life easier, take a look at the SQL Developer Suite.

A clear path through database deployment

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

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 you're ready to deploy, SQL Compare Pro detects your development changes.

With source control and SQL Compare's 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.