Redgate SQL Compare

Compare, sync, and deploy SQL Server schemas

Subcategories

Average rating

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

About this software

Redgate SQL Compare compares and synchronizes Microsoft SQL Server database schemas, highlighting differences and generating T-SQL deployment scripts. It compares live databases, backups, and folders of SQL scripts, and runs inside SQL Server Management Studio for interactive review. Command-line automation and CI/CD integration are available but may require additional Redgate licensing or Toolbelt products. Some objects, such as encrypted objects and certain replication-related procedures, are not fully compared or deployable.

Licenses & prices

Standard

Standard edition provides core schema comparison and manual deployment features through the Redgate SQL Compare desktop.

Professional

Professional edition includes Standard features plus automation, command-line tools, and source control integration for CI/CD.

Sql compare

Redgate SQL Compare for ad-hoc schema comparisons and visual deployments of SQL Server databases through a GUI.

Sql compare professional

Redgate SQL Compare Professional adds automation and scripting for repeatable schema deployments and continuous integration.

Purchase

Redgate SQL Compare

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

Do you need more information or looking for another license?

Benefits

  • Schema comparison: Highlights differences between two SQL Server database schemas quickly.
  • Generate deployment scripts: Produces T-SQL scripts to update target schemas safely.
  • Integrates with SSMS: Works inside SQL Server Management Studio for direct comparisons.
  • Command-line automation: Command-line use requires additional Redgate licensing or Toolbelt integration.
  • Handles scripts and backups: Compares folders of scripts and backup files as comparison sources.

Available languages

  • English

Support information

  • Documentation: Comprehensive online documentation includes getting started, options, troubleshooting, and release notes.
  • Product help articles: Product help articles cover common errors and fixes for SQL Compare.
  • Support forum: A community forum allows peer Q&A and feature discussions.
  • Redgate University: Self-paced training courses are available through Redgate University.
  • Contact support team: Licensed customers can contact Redgate support via the product portal or support channels.

Frequently asked questions

What does SQL Compare do for databases?
It compares SQL Server database schemas, shows differences, and generates T-SQL scripts to synchronize targets.
Which sources can SQL Compare compare?
It can compare live SQL Server databases, backup files, and folders of SQL scripts.
Can SQL Compare be automated in CI/CD?
Command-line use and CI/CD automation are available, but may require additional Redgate licensing or Toolbelt products.
Does it integrate with SQL Server Management Studio?
Yes, it integrates with SQL Server Management Studio for interactive comparisons and deployments.
What are known limitations of SQL Compare?
Some object types are not fully supported; encrypted objects and certain replication-generated procedures cannot be compared or deployed.