Compare and deploy SQL Server database contents
Try SQL Data Compare free for 14 days
Introduction 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. 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 daysStandard
$495 per user
Compares and synchronizes SQL Server database contents
Pro
$745 per user
Automate comparisons and migrations, and recover individual rows by comparing databases to backups
Part of the SQL Toolbelt
Key features
Do all this with SQL Data Compare Standard
- Save time comparing and synchronizing data
- Copy lookup data from development databases to staging or production
- Generate T-SQL scripts to update one database with the contents of another
- Keep an accurate history of all previous database records
- Compare and synchronize data from within SQL Server Management Studio
- Deploy to SQL Server, SQL Azure, and SQL Server on Amazon RDS
Do even more with SQL Data Compare Pro
- Quickly fix problems by restoring damaged or missing data to a single row
- Deploy databases from source control
- Compare and synchronize from backup files
- Automate comparison and synchronization tasks with DLM Automation
- Run SQL Data Compare Pro on your build server for continuous integration, with DLM Automation
Full list of features
| What can I compare and synchronize? | Standard | Pro |
|---|---|---|
| SQL Server 2005, 2008, 2012, 2014, 2016, SQL Azure, & SQL Server on Amazon RDS databases | ||
| Native, encrypted, & compressed SQL Server 2005, 2008, & 2012 backup files | ||
| SQL Server 2014 backup files | ||
| Redgate SQL Backup Pro files | ||
| Folders of SQL scripts (for source control) |
| Features | Standard | Pro |
|---|---|---|
| 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 | ||
| Command line automation (If you're using the command line on a build server, youll need DLM Automation) | ||
| Fast table, column, or row level restore of damaged or missing data |
Screenshots
Select what you want to compare
Select data to deploy
Create a manual deployment script
The databases are identical
Compare and manually deploy database contents from within SSMS
Case Study
“I synchronize scripts and changes across anywhere from 2 to 200 databases at the same time using SQL Compare Pro and SQL Data Compare Pro.”
— John Trumbul, Senior Software Engineer, Lumidata
Lumidata uses SQL Data Compare Pro as part of the SQL Toolbelt.
Find out how John Trumbul saved a half-year of a developer's salary in his first three months of using the SQL Toolbelt.
Automated data syncing with SQL Data Compare Pro and TeamCity
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 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.”
“I developed a small time-tracking system for my company. The development version sits on my laptop and the production version runs SQL Server on our network. Since the database is still quite tiny, I like to keep both versions in close synchronization.
After returning from PASS there was a difference of nearly 50,000 records. SQL Data Compare had the systems synchronized before I would have finished typing out the T-SQL backup command.”