$395
from

$494 including support & upgrades

SQL Data Compare™

Latest version: 8.1

Compares and synchronizes SQL Server database contents

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



Over 90,000 professionals use SQL Data Compare to:

Yes Save time by automatically comparing and synchronizing your data

Yes Copy lookup data from development databases to staging or production

Yes Generate T-SQL scripts to update one database with the contents of another

Yes Quickly fix problems by restoring damaged or missing data to a single row

Yes Keep an accurate history of all previous database records

View the 2 minutes introduction video to SQL Data Compare

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

You can work with live databases, backups, or SQL scripts in source control. With the command line interface you can automate tasks and schedule comparisons to easily create an audit trail. Damaged or missing data can be restored to a single row, without the need for a full database recovery.

SQL Data Compare helps you compare and delpoy changes quickly, simply, and with zero errors.

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

Selecting what you want to compare screenshot Selecting the data to synchronize screenshot Creating a migration script screenshot The databases are identical screenshot
Selecting what you want to compare
Selecting data to synchronize
Creating a migration script
The databases are identical


Key features Standard Pro
Compare and deploy changes to SQL Server database contents
Yes
 Yes
Automatically create error-free synchronization scripts
Yes
 Yes
Build sophisticated rules to selectively limit what to synchronize
Yes
 Yes
Index view support so data differences are seen on both views and tables
Yes
 Yes
Support for Microsoft SQL Server 2000, 2005 & 2008 databases
Yes
 Yes
Create an audit trail by comparing backups   Yes
Backup target database before changes are migrated   Yes
Command line automation for continuous integration Yes
Fast table, column, or row level restore of damaged or missing data Yes


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


Buying SQL Data Compare
Buying SQL Compare

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

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

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

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

   SQL Toolbelt
   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 Data Compare Professional to shopping cart

Add SQL Data Compare Professional to shopping cart
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."
Robin Dewson, Technical Lead, Nomura International

"With Data Compare I am 100% confident that work I do on my SQL Server database while on the move, can be cross checked and synchronised with my server in the office with just a few clicks giving me an extra 3 hours productivity a day and no fears of a change being missed."
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."
George Pantela, GPAnalysis.com

"We use SQL Data Compare daily and it has become an indispensible part of delivering our service to our customers. It has also streamlined our daily update process and cut back literally a good solid hour per day."
Jasper Smith, SQL Server MVP

"With SQL Data Compare, I can save up to several hours for each database."
Learn more
Feedback Form