SQL Data Compare
Compare and deploy SQL Server database contents
SQL Data Compare starts at
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 deploy changes quickly, simply, and with zero errors.
- 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
- Quickly fix problems by restoring damaged or missing data to a single row
- Keep an accurate history of all previous database records
- Compare and synchronize data within SSMS
- Deploy to SQL Azure databases, or SQL Server on Amazon RDS
Do this and more with SQL Data Compare Pro:
- Deploy databases from source control
- Compare and synchronize from backup files
- Command line automation for continuous integration (requires a license of the SQL Automation Pack)
For more information on the differences between Pro and Standard see the features page.
With our full set of SQL development tools you can code fast, collaborate easily, and deploy accurately. Sound good?
"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
John uses SQL Data Compare as part of the SQL Toolbelt.
Learn how Lumidata saved a half-year of a developer's salary in his first three months with the SQL Toolbelt.
Find out how Troy Hunt used SQL Data Compare to sync data back down from production, to his test and development environments.
"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."
George Pantela, GPAnalysis.com
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.
Robin Dewson, Technical Lead, Nomura International
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.
Paul Tebbutt, Technical Lead, Universal Music Group
I developed a small time-tracking system for my company. The development version sits on my laptop and the production version runs SQL Server 2005 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.
Michael Garstin, SQL Server Support Technical Lead, VMC Canada
SQL Data Compare 11 beta
Try the SQL Data Compare 11 beta for more SQL Server 2014 support. With the beta, you'll be able to:
- Deploy data in memory-optimized tables
- Deploy data in tables with clustered columnstore index
You can try the beta alongside SQL Data Compare 10. Let us know what you think, and help us build the SQL Data Compare you’d like to see.
Got any questions?
+44 (0)1223 437 922
Try SQL Data Compare
Download a 14-day free trial, and start saving time with your database deployments.