Redgate SQL Data Compare

Compare and deploy SQL Server data

Average rating

Deze score is berekend door AI op basis van publiek beschikbare informatie.
4.6 / 5

About this software

SQL Data Compare compares and deploys data between Microsoft SQL Server databases, backups, and script folders. It highlights row-level differences and generates deployment scripts or updates to synchronize target databases while preserving referential integrity. The Pro edition adds row-level restore, backup comparison, source-control deployment, and automation features suitable for CI/CD. Use it interactively in SSMS or via command-line and APIs for automation.

Licenses & prices

Standard

GUI tool to compare and synchronize SQL Server database data, generate synchronization scripts, and apply changes interactively.

Professional

Includes Standard features plus command-line automation, continuous integration server integration, and advanced filtering for scripted deployments.

Sql data compare

Desktop application for comparing and synchronizing table data between SQL Server databases, producing deployable synchronization scripts and reports.

Purchase

Redgate SQL Data Compare

Redgate SQL Data Compare
In Stock
Delivery: 1 working day
Loading...
€316.76
Free and without obligation

Do you need more information or looking for another license?

Benefits

  • Row-level comparisons: Displays precise row differences between SQL Server databases for targeted changes.
  • Deployment scripts: Generates error-free T-SQL scripts to update target databases.
  • Backup and script support: Can compare backups and script folders as data sources.
  • SSMS and CLI integration: Integrates with SQL Server Management Studio and offers a command-line interface.
  • Automation and CI: Pro edition supports automation and CI/CD workflows via APIs and build servers.

Available languages

  • English

Support information

  • Product documentation: Comprehensive product documentation and user guides available on Redgate's documentation site.
  • Support forum: Community forums provide peer answers and product discussions moderated by Redgate staff.
  • Product help articles: Searchable help articles and troubleshooting tips are available on the product support portal.
  • Redgate University: Self-paced courses and videos cover product workflows and best practices.
  • Contact support: Licensed users can contact Redgate support or sales through the website for assistance.

Frequently asked questions

What is Redgate SQL Data Compare used for?
A tool for comparing and synchronizing data between Microsoft SQL Server databases, identifying row-level differences and generating scripts to update target databases.
Which database platforms does Redgate SQL Data Compare support?
Designed for Microsoft SQL Server databases; performs comparisons of tables and their data within SQL Server environments.
How can comparisons be scoped for large databases or specific data?
Options to include or exclude specific tables, filter rows, and compare selected columns let users limit comparison scope and focus on relevant data.
What outputs are produced after running a comparison?
Side-by-side difference views, a summary report of changes, and a generated SQL synchronization script that can be reviewed before applying updates.