Redgate SQL Data Compare

Compare and deploy SQL Server data
Buy now Contact

Publisher

Red Gate Software

Subcategories

Data Modeling & Design

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

Standard edition provides core interactive data comparison and synchronization through the GUI but excludes advanced automation features.

Professional

Professional edition offers full-featured SQL Server data comparison with automation, filtering, and command-line support for complex workflows.

Sql data compare

Sql data compare compares and synchronizes SQL Server database contents, showing differences and generating synchronization scripts.

Sql data compare professional

Sql data compare professional provides advanced database data comparison, synchronization, command-line automation, and granular deployment options.

Purchase

Redgate SQL Data Compare

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

Do you need more information or looking for another license?

envelope Get in contact phone Call me calendar Schedule a meeting

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

Which database platforms does SQL Data Compare support?
It works with Microsoft SQL Server instances, SQL Azure, and SQL Server on Amazon RDS, including live databases, backups, and script folders.
Can SQL Data Compare run from the command line?
Yes; it offers command-line support and APIs, with automation features available in the Pro edition for CI/CD and build servers.
What additional capabilities does the Pro edition include?
Pro adds fast row-level restore, backup-file comparisons, integration with source control, and automation for continuous integration and build servers.
How does SQL Data Compare handle referential integrity during sync?
It preserves referential integrity by ordering changes and supporting multi-table synchronization to avoid breaking constraints.
Who is SQL Data Compare intended for?
DBAs, developers, and teams needing to compare, synchronize, or restore SQL Server data across development, test, and production environments.