Detect and Fix Errors Fast in Production
Feature HighlightDatabase Comparison Tools
SQL Compare resolves production issues with precision and minimal risk by deploying targeted fixes without requiring full restores or downtime.
SQL Compare
Compare and deploy SQL Server database schemas quickly and accurately.
- Compare SQL Server database schemas and identify structural differences across environments.
- Generates error-free deployment scripts with dependency ordering.
- Offers detailed comparison views, filtering, and various authentication methods.
Prices from:
Loading...
| Available individually | Our Price |
|---|---|
| SQL Compare | Loading |
| Also available in | |
|---|---|
| SQL Toolbelt Essentials | Loading |
Need help choosing? See How to Buy and Specification
SQL Compare is a comprehensive component designed to compare and deploy SQL Server database schemas. It supports advanced features like SQL Graph, temporal tables, and Azure Active Directory authentication. Users can generate clear difference reports, create error-free deployment scripts, and automate deployments efficiently.
Schema comparison and synchronization
Allows comparison of two SQL Server databases to examine differences at granular levels, including filtering database objects and producing detailed reports in HTML or Excel formats.
Error-free deployment scripting
Automatically creates deployment scripts with correct dependency ordering. Provides warnings for potential issues such as data loss before the deployment is performed.
Flexible deployment options
Enables deployment of individual schema differences or selected groups, run directly from the user interface or command line, as well as saving deployment scripts for later use.
Advanced difference viewing
Provides multiple views for examining differences including a SQL view and a summary view that highlights semantic changes in a structured and readable format.
Enhanced support for modern SQL Server features
Includes support for SQL Graph capabilities introduced in SQL Server 2017 and improved handling of temporal tables with custom history retention policies and indexes.
Secure and modern authentication methods
Supports Azure Active Directory authentication with integrated and password methods, along with the secure saving of login credentials for databases and servers.
Integration with Redgate ecosystem
Integrates with SQL Monitor to display detected deployments within dashboards. Also compatible with other Redgate products for command line automation and continuous integration workflows.
Product Compatibility
Review the details below to ensure this product is supported within your environment.
Database Support
- Microsoft SQL Server
Operating System
- Windows Desktop
- Windows Server
Windows Desktop Version
- Windows 10
- Windows 8.1
- Windows 8
- Windows 7
Windows Server Version
- Windows Server 2019
- Windows Server 2016
- Windows Server 2012
- Windows Server 2008
How to Buy
Available individually or as part of SQL Toolbelt Essentials.
This Page
SQL Compare
- SQL Compare Features
- IncludedFind differences and sync SQL Server schemas
- IncludedAuto-generate update scripts
- IncludedSupports multiple sources with filtering
- IncludedCLI support and CI/CD integration
- Additional Products
- Not includedSQL Data Compare
- Not includedSQL Data Generator
- Not includedSQL Dependency Tracker
- Not includedSQL Doc
- Not includedSQL Multi Script
- Not includedSQL Prompt
- Not includedSQL Source Control
- Not includedSQL Test
- SQL Compare Features
- IncludedFind differences and sync SQL Server schemas
- IncludedAuto-generate update scripts
- IncludedSupports multiple sources with filtering
- IncludedCLI support and CI/CD integration
- Additional Products
- IncludedSQL Data Compare
- IncludedSQL Data Generator
- IncludedSQL Dependency Tracker
- IncludedSQL Doc
- IncludedSQL Multi Script
- IncludedSQL Prompt
- IncludedSQL Source Control
- IncludedSQL Test
Automate Database Updates with Direct Deployment
Product UpdateDatabase Comparison Tools
SQL Compare offers streamlined deployment of SQL Server schema changes directly to your target environment, eliminating manual scripting.
About Redgate Software
Redgate Software, founded in 1999 and headquartered in Cambridge, UK, specializes in database management solutions trusted by more than 200,000 customers worldwide. It is recognized for enabling IT professionals and organizations to address the complexities of database DevOps across diverse environments. Popular products such as Redgate Flyway, Redgate Monitor, and Redgate Test Data Manager support efficient development cycles, data security, and high-quality releases. With a global presence and adoption by 92% of the Fortune 100, Redgate stands out for its commitment to simplifying database processes and supporting industry best practices.
Learn more about Redgate SoftwareExplore Redgate Software products
As official and authorized distributors since 2005, ComponentSource supplies you with legitimate licenses directly from Redgate Software.