Save Big on Cyber Monday! Up to 40% Off
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

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
Professional
Full-featured edition
Subscription
$279.95
Buy now
Standard
Basic functionality
Subscription
$219.95
Buy now
Features
Connectivity
Connectivity to Servers and Clouds
Professional
Standard
SQL Server 2022
Yes
Yes
SQL Server 2000 - 2019
Yes
Yes
SQL Server installed on Linux
Yes
Yes
Azure Synapse Analytics Dedicated SQL pools
Yes
Yes
Azure Synapse Analytics Serverless
Yes
Yes
Microsoft Fabric Data Warehouse
New
Yes
Yes
Microsoft OneLake
New
Yes
Yes
SQL Database in Microsoft Fabric
New
Yes
Yes
SQL Server on Amazon RDS databases
Yes
Yes
Azure SQL Database (SQL DB)
Yes
Yes
Azure SQL Managed Instance (SQL MI)
Yes
Yes
Microsoft Entra multi-factor authentication (MFA) (formerly Azure Active Directory (Azure AD))
Yes
Yes
Heroku Cloud
Yes
Yes
Azure DevOps, Git, SVN, TFS, P4, Vault, Mercurial, Plastic SCM
Yes
None
Integration
Integration
Professional
Standard
Database comparison directly from Microsoft SQL Server Management Studio (SSMS)
Yes
\Yes
Sources
Sources to compare, synchronize, and deploy
Professional
Standard
All SQL Server database objects
Yes
Yes
SQL Server Database properties
Yes
\Yes
SQL objects with different owners, with the help of schema mapping
Yes
\Yes
Tables with different names, with the help of table mapping
Yes
\Yes
Snapshots of the schema to build a continuous audit trail of all SQL schema changes
Yes
Yes
Scripts folders as a set of object creation scripts representing a database schema
Yes
No
Objects stored in source control in SQL files
Yes
No
Native SQL Server backups for object-level recovery
Yes
No
Data-tier application packages (DACPAC)
Yes
No
Options
Options
Professional
Standard
Compare and deploy changes to SQL Server database schemas (from development, to test, to production environments)
Yes
Yes
Generate error-free T-SQL deployment scripts that update one SQL Server database to match the schema of another
Yes
Yes
Review deployment warnings about anything you need to be aware of before updating SQL Server schemas
Yes
Yes
Save readable schema update deployment scripts for later use or review by your colleagues
Yes
Yes
Rely on automatically checking the dependency of the object that uses scripting objects in the correct order for updates
Yes
Yes
Perform a comparison of the content of encrypted stored routines that were created with the help of the WITH ENCRYPTION clause
Yes
Yes
Save schema comparison and synchronization settings to a project for re-execution later
Yes
Yes
Migrate a selection of individual schema differences between the SQL objects in the source and destination databases
Yes
Yes
Save database schema snapshots for audit and roll-back purposes
Yes
Yes
Compare two revisions in the same branch of the version control system to restore databases as of the point-in-time state
Yes
No
Deploy scripts saved as SQL files in source control to a new or existing SQL database
Yes
No
Restore a single object or selection of objects from a SQL Server backup file
Yes
No
Analyzing differences
Analyzing differences and reporting changes
Professional
Standard
View comparison details, including script-level differences
Yes
Yes
Exclude or include objects to analyze with fine-customizable filtering of database objects
Yes
Yes
Tune the diffs' appearance with grouping by type of differences
Yes
Yes
Examine the impact of the synchronization script before it is executed, including warning levels and messages
Yes
Yes
Use a built-in T-SQL editor with code completion to review and edit SQL scripts before execution
Yes
Yes
Troubleshoot database differences and export objects diff results to XML, Excel, and HTML file formats
Yes
Yes
Well-designed and flexible HTML report generation detailing database differences
Yes
Yes
Automation
Automation
Professional
Standard
Create a custom pre- and post-processing script
Yes
Yes
Schedule tasks with the command-line interface (CLI)
Yes
No
Convert the project comparison & sync options into the command-line syntax and save it as a *.bat file with the CLI Wizard
Yes
No
Retrieve the status of the comparison and synchronization process with the CLI Wizard
Yes
No
Tune the compare and sync process with a wide range of command-line options
Yes
No
Use the tool along with dbForge DevOps Automation for SQL Server to implement Continuous Integration (CI)
Yes
No
$279.95
Buy Now
$219.95
Buy Now