Choose an edition that's right for you

dbForge Schema Compare for SQL Server comes in two editions:

Standard edition contains all basic functionality that helps you quickly and efficiently compare, merge and synchronize SQL Server database schemas.

Professional edition comes with a full package of advanced features that allow you to compare native SQL Server backups, create and compare database schema script folders, perform version control schema comparison and use a command line interface, all the while supporting SVN, TFS, P4, Vault, GIT, Mercurial, Plastic SCM, Azure DevOps - and much more!

The matrix below compares features of dbForge Schema Compare Standard and Professional editions.

Most popular

$269_.95

Buy now

$219_.95

Buy now

Features

Connectivity to Servers and Clouds

Professional

Standard

SQL Server 2022

New

SQL Server 2000 - 2019

SQL Server installed on Linux

Azure Synapse Analytics (formerly Azure SQL Data Warehouse (SQL DW)) Serverless but not Dedicated

SQL Server on Amazon RDS databases

Azure SQL Database (SQL DB)

Azure SQL Managed Instance (SQL MI)

Microsoft Entra multi-factor authentication (MFA) (formerly Azure Active Directory (Azure AD))

Heroku Cloud

Azure DevOps, Git, SVN, TFS, P4, Vault, Mercurial, Plastic SCM

Integration

Professional

Standard

Database comparison directly from Microsoft SQL Server Management Studio (SSMS)

$\Yes$

Sources to compare, synchronize, and deploy

Professional

Standard

All SQL Server database objects

SQL Server Database properties

$\Yes$

SQL objects with different owners with the help of schema mapping

$\Yes$

Tables with different names with the help of tables mapping

$\Yes$

Snapshots of the schema to build a continuous audit trail of all SQL schema changes

Scripts folder as a set of object creation scripts representing a database schema

Objects stored in source control in SQL files

Native SQL Server backups for object-level recovering

Data-tier application packages (DACPAC)

Options

Professional

Standard

Compare and deploy changes to SQL Server database schemas (from development, to test, to production environments)

Generate error-free T-SQL deployment scripts that update one SQL Server database to match the schema of another

Review deployment warnings about anything you need to be aware of before updating SQL Server schemas

Save readable schema update deployment scripts for later use or the review your colleagues

Rely on automatically checking the dependency of the object that uses for scripting objects in the correct order for updates

Perform a comparison the content of encrypted stored routines that created with help of the WITH ENCRYPTION clause

Save schema comparison and synchronization settings to a project for re-execution later

Migrate a selection of individual schema differences between the SQL objects in the source and destination databases

Save database schema snapshots for audit and roll-back purposes

Compare of two revisions in the same branch of the version control system to restore databases as of the point-in-time state

Deploy scripts saved as SQL files in source control to a new or existing SQL database

Restore a single object or selection of objects from a SQL Server backup file

Analyzing differences and reporting changes

Professional

Standard

View comparison details including script-level difference

Exclude or include objects to analyze with fine-customizable filtering of database objects

Tune the diffs appearance with grouping by type of differences

Examine the impact of the synchronization script before it is executed, including warning levels and messages

Use a built-in T-SQL editor with code completion to review and edit SQL scripts before execution

Troubleshoot database differences and export objects diff results to XML, Excel, HTML file formats

Well-designed and flexible HTML report generation detailing database differences

Automation

Professional

Standard

Create custom pre- and post-processing script

Schedule tasks with the command-line interface (CLI)

Covert the project comparison & sync options into the command-line syntax and save it as a *.bat file with CLI Wizard

Retrieve the status of comparison and synchronization process with CLI Wizard

Tune the compare and sync process with a wide range of command-line options

Use the tool along with dbForge DevOps Automation for SQL Server to implement Continuous Integration (CI)

$269.95

Buy Now

$219.95

Buy Now