Download the latest version →
If you are a new user, click the or "Download" button on the product page.
Sometimes, data in your live app gets corrupted.You can compare live data against a backup.The tool restores only the missing or broken rows. Testing Apps with Real Data
: You can apply "WHERE" clauses to your comparisons, allowing you to compare only a subset of data within a table. This is particularly useful when dealing with very large tables or when you only need to verify specific data ranges.
Yes. Licensed versions (such as those in the SQL Toolbelt standard/pro tiers) include a robust command-line interface. This allows you to automate comparisons via PowerShell, batch files, or your DevOps CI/CD tools. Streamline Your Database Deployments redgate sql data compare download
: Open SQL Data Compare or access it via the SSMS "Tools" menu. Select Sources
It supports SQL Server (2012 and later), Azure SQL Database, and Amazon RDS for SQL Server. How to Install After Downloading Once you’ve downloaded the .exe file, follow these steps:
Once the file is on your computer, you can install it.The process takes less than five minutes. : Double-click the downloaded installer. Select the tool : Check the box for SQL Data Compare . Click Install : Follow the prompts on your screen. Finish : Launch the app once the setup is done. Why Use SQL Data Compare?
When comparing large or remote databases, you can significantly improve performance by keeping a few best practices in mind: Download the latest version → If you are
It was beautiful.
: A 14-day fully functional free trial is available on the Redgate official website.
: Allows users to include or exclude specific rows and columns (e.g., "target only" rows) through the UI or command line. : Generates Interactive HTML reports
When you launch the tool for the first time, you'll be prompted to create a new project. This project will store your settings and can be saved and reused later. This is particularly useful when dealing with very
SQL Data Compare supports comparisons between on‑premises SQL Servers and cloud databases like Microsoft Azure SQL Database, smoothing the transition to cloud environments.
This feature allows you to select which changes to deploy. It provides a final summary and generates the synchronization script, which you can run immediately or save. Common Use Cases
If the installation fails midway, delete your browser cache and re-download the file.
✅ Important : It compares – not schemas (that’s SQL Compare ). For schema + data together, use SQL Compare + Data Compare together.