Redgate logo for print use
New report2025 State of database landscape cover

2025 State of the Database Landscape− download the report

Get an overview of our solutions

Redgate Test Data Manager

Improve your release quality and reduce your risk, with the flexibility to fit your workflow

Redgate Flyway

Bring stability and speed to database deployments

Redgate Monitor

Understand server performance in an instant with fast deep-dive analysis

See all our products

SQL Data Compare

Compare and deploy SQL Server database contents

Try SQL Data Compare free for 14 days.

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 days.

1 Year Subscription

Loading/user

Equivalent to Loading/user/mo

Buy now

Part of SQL Toolbelt Essentials

Considering a longer-term contract?

Ask us about available discounts on SQL Data Compare

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 SQL Change Automation
  • Run SQL Data Compare Pro on your build server for continuous integration, with SQL Change Automation

Screenshots

Select what you want to compare

Select what you want to compare

Select data to deploy

Select data to deploy

Create a manual deployment script

Create a manual deployment script

The databases are identical

The databases are identical

Compare and manually deploy database contents from within SSMS

Compare and manually deploy database contents from within SSMS

Troy Hunt

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.”

George Pantela, GPAnalysis.com

“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.”

Robin Dewson, Technical Lead, Nomura International

“SQL Compare and SQL Data Compare are the best purchases we've made in the .NET/SQL environment.”

Paul Tebbutt, Technical Lead, Universal Music Group

“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.”

Greg White, Senior DBA at SAGA Insurance
SQL Data Compare: Compare And Synchronize SQL Server Database Contents