How to compare and deploy SQL Server database contents with SQL Data Compare (3:29)
You can work with live databases, backups, or SQL scripts in source control. 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 deploy changes quickly, simply, and with zero errors.Try SQL Data Compare free for 14 days
|What can I compare and synchronize?
|SQL Server 2008, 2012, 2014, 2016, 2017, 2019, SQL Azure, & SQL Server on Amazon RDS databases
|Native, encrypted, & compressed SQL Server 2008, & 2012 backup files
|SQL Server 2014 backup files
|Redgate SQL Backup Pro files
|Folders of SQL scripts (for source control)
|New Linux command-line support (beta)
|Compare and deploy changes to SQL Server database contents
|Compare and synchronize data from within SSMS
|Automatically create error-free synchronization scripts
|Build sophisticated rules to selectively limit what to synchronize
|Index view support so data differences are seen on both views and tables
|Comparison on primary keys and unique indexes so you can define identical rows
|Custom comparison keys to compare databases based on any field
|Pivot-view difference navigation to display row data as columns
|Comparison and synchronization of large databases
|Create an audit trail by comparing backups
|Backup target database before changes are migrated
|Run deployments from the command line*
|Fast table, column, or row level restore of damaged or missing data
* To use Redgate's command line tools as part of a Redgate Pipeline (an automated database change delivery process) a Flyway Enterprise, Redgate Deploy or SQL Toolbelt license is required. For more information, see the Product Specific Terms.
Software architect and Microsoft MVP Troy Hunt uses SQL Data Compare Pro to sync data back down from production, to his test and development environments.Read the article
“We use SQL Data Compare daily and it has become an indispensable 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.”
“SQL Data Compare and SQL Compare are two of the most important tools I have in my development operation. I can be so responsive to end-user requests for new features using the tools to deploy upgrades to my SaaS application (which by the way has 100% uptime for the last 7 consecutive months) because of the excellent work by Redgate.”
“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.”
“Redgate SQL and Data Compare tools are absolute essential tools for me. It’s so quick easy to see changes between databases / environments and bring them into alignment.”