Red Gate logo

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

$745

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

Plus do even more with SQL Compare Pro

  • Deploy databases from source control

  • Compare and synchronize from backups

  • Command line automation

  • Run SQL Compare on your build server for continuous integration (with the SQL Automation Pack)

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 & Red Gate SQL Backup Pro)
Folders of SQL scripts (for source control)
FeaturesStandardPro
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 on your local dev machine (If you're using the command line on a build server, you'll need the SQL Automation Pack)
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

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, centralized deployment

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. It includes your scripts in the deployment script it generates, to ensure all your changes are deployed as you intended.

SQL Compare Pro also provides a diagram of the change path and the option to review each script, so you have complete oversight of the updates you're making.

Screenshots

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

DLM - Stage 1: Manual

One of Red Gate’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 Red Gate can help.

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