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

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

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 needs to create a view

Static data from a local scripts folder as a set of object creation scripts representing 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 tables mapping

Data source SQL objects with different column names with the help of columns 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 to automapping tables, views, columns by mask

Native SQL Server backups for row-level recovering

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 for scripting objects in the correct order for data updates

Save concise data update deployment scripts for later use or the review 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 tables 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, HTML file formats

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

$269.95

Buy Now

$219.95

Buy Now