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 GUI-based schema comparison and synchronization for single SQL Server databases with basic filtering.

Professional

Professional edition adds command-line automation, CI/CD integration, and advanced deployment options for scripted or automated workflows.

Sql compare

SQL Compare performs quick database schema comparisons and generates synchronization scripts via an intuitive graphical interface.

Purchase

Redgate SQL Compare

Redgate SQL 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

  • 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 Redgate SQL Compare do?
Compares SQL database schemas to identify object-level differences and generates a SQL script to synchronize or update target databases, with results shown for review.
How are database changes deployed between servers?
Produces a deployment script reflecting schema differences; scripts can be exported for review or executed to apply changes to a target database.
Can comparisons be customized or filtered?
Comparison settings allow inclusion or exclusion of object types, name-based filters, and adjustable sensitivity for differences to focus results on relevant changes.
Is automation and CI/CD integration supported?
Includes automation interfaces suitable for scripting and continuous integration pipelines, enabling scheduled or pipeline-driven comparisons and generation of synchronization scripts.