$395
from

$494 including support & upgrades

SQL Compare®

Latest version: 8.2

Compares and synchronizes SQL Server database schemas

Download SQL Compare
 Download your 14-day, free trial of SQL Compare 8



Over 200,000 professionals use SQL Compare to:

Yes Save time by automatically comparing and synchronizing database schemas

Yes Eliminate mistakes migrating database changes from dev, to test, to production

Yes Speed up the deployment of new database schema updates

Yes Generate T-SQL scripts to update one database to match the schema of another

Yes Find and fix errors caused by differences between databases

Yes Deploy a database from source control

Need a version of SQL Compare that works with Oracle? Download Schema Compare for Oracle


View the 2 minute introduction video to SQL Compare

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

54% of the Fortune 100 use SQL Compare – because it's relentlessly tested, because it's 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.

Download your 14-day, free trial of SQL Compare 8

Selecting what you want to compare screenshot Comparison results screenshot Synchronization wizard The databases are identical
Selecting what you want to compare
Selecting objects to synchronize
Creating a migration script
The databases are identical


Key features Standard Pro
Compare and deploy changes to SQL Server database schemas Yes Yes
Automatically create error-free synchronization scripts Yes Yes
Migrate individual, a selection of, or all schema differences Yes Yes
Build sophisticated rules to selectively limit what to synchronize Yes Yes
Support for Microsoft SQL Server 2000, 2005 & 2008 databases Yes Yes
Create reports detailing database differences Yes Yes
Troubleshoot database differences Yes Yes
Backup target database before changes are migrated Yes
Command line automation for continuous integration Yes
Automatically output a database into individual object creation scripts Yes
Restore just a single object (or selection of objects) from a backup file Yes


What can I compare and synchronize? Standard Pro
SQL Server databases Yes Yes
Snapshots of the schema Yes Yes
Backup files (both native SQL Server & Red Gate SQL Backup) Yes
Folders of SQL scripts (for source control) Yes


Buying SQL Compare
Buying SQL Compare

Add SQL Compare Professional to shopping cart          Add SQL Compare Professional to shopping cart

...SQL Compare is also available in these bundles:

   Includes SQL Compare Standard ...and 3 companion tools for 55% saving
$695

   Includes SQL Compare Pro ...and 9 companion tools for 65% saving
$1,295

   Every SQL Pro tool Red Gate does ...for a massive 70% saving
$1,995
2 out of 3 people who use a SQL Comparison tool use Red Gate


Add SQL Compare Professional to shopping cart

Add SQL Compare Professional to shopping cart
Jeremy McCollum, Senior Software Developer, Fluid Audio Networks

"I rely on Red Gate for 90% of my DB versioning process."
Brian Pond, IT AX Manager, Border Construction Specialties

"In my personal and professional opinion, SQL Compare and SQL Data Compare are absolutely essential for any SQL database administrator, developer, or architect, regardless of their level of experience."
Matt DeWitt, Database Architect, 3M HIS

"I use SQL Compare every day. It's fast, helpful and reliable. What more could I ask for?"
Adam Machanic, SQL Server MVP

"Red Gate's tools are generally considered to be the gold standard. SQL Compare is fast, extremely easy to use – Red Gate pays a huge amount of attention to its UIs – full-featured and affordable. I wouldn't bother messing around with anything else."
Penny Spokes, Digital Interactive

"We use the SQL Compare tool constantly for moving stuff from dev to live. Frankly, we couldn't cope without it now."
Paul Tebutt, Technical Lead, Universal Music Group

"SQL Compare and SQL Data Compare are the best purchases we've made in the .NET/SQL environment. They've saved us hours of development time and the fast, easy-to-use database comparison gives us maximum confidence that our migration scripts are correct. We rely on these products for every deployment."
Learn more
Feedback Form