Choose an edition that's right for you

dbForge Data Compare for SQL Server comes in two editions:

Standard edition includes all the features necessary to quickly and easily compare and sync data in SQL Server databases.

Professional edition is a powerful, full-featured software with a set of advanced features allowing to compare static data from local scripts folder, native SQL Server backups, use command line interface to compare data, and much more.

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

Features

Connectivity to Servers and Clouds

Professional

Standard

SQL Server 2022

SQL Server 2000 - 2019

SQL Server installed on Linux

Azure Synapse Analytics Dedicated SQL pools

Azure Synapse Analytics Serverless

Microsoft Fabric Data Warehouse

New

Microsoft OneLake

New

SQL database in Microsoft Fabric

New

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

Integration

Professional

Standard

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

$\Yes$

Sources to compare, synchronize, and deploy

Professional

Standard

Tables

Views

Results of custom queries without the need to create a view

Static data from a local scripts folder as a set of object creation scripts representing the database schema and table data

Data source SQL objects with different owners with the help of schema mapping

Data source SQL objects with different names, with the help of table mapping

Data source SQL objects with different column names, with the help of column mapping

Data source SQL objects with different column data types with the help of data compatibility

Key-independent comparison with a custom comparison key to compare data in tables without a primary key or UNIQUE constraints

Selectively limit what data will be compared and synchronized with data-level filtering

Exclude or Include automapping tables, views, columns by mask

Native SQL Server backups for row-level recovery

Options

Professional

Standard

Compare and deploy data changes with zero errors (from dev, to test, to prod)

Generate accurate T-SQL deployment scripts that update one SQL Server database to match the data of another

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

Save concise data update deployment scripts for later use or review by your coworkers

Migrate a selection of individual data differences between the tables in the source and target databases

Review deployment warnings about anything you need to be up-to-date with before updating data in SQL Server tables

Save data comparison and synchronization settings to a project for rerunning later

Restore damaged or missing data to a single row from a SQL Server backup file, without the need for a full database recovery

Analyzing differences and reporting changes

Professional

Standard

View data comparison results grouped by types of differences

View data comparison details, including row-level differences

View data comparison details, including data-level differences

Exclude or include tables to deploy the differences with the name filtering of database objects

Exclude or include the table data to synchronize

Tune the data diffs

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

Use an embedded SQL editor with code completion to review and edit SQL scripts before execution

Troubleshoot data differences and export data level diff results to CSV, Excel, and HTML file formats

Automation

Professional

Standard

Create a custom pre- and post-processing script

Schedule tasks with the command-line interface (CLI)

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

Retrieve the status of the comparison and synchronization process with the CLI Wizard

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

$279.95

Buy Now

$219.95

Buy Now