dbForge Compare Bundle for SQL Server

Schema Compare

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, TFVC), Git (GitHub, GitLab, BitBucket), SVN

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 to implement Continuous Integration (CI)

Data Compare

Connectivity to Servers and Clouds

Professional

Standard

SQL Server 2022

New

SQL Server 2000 - 2019

SQL Server installed on Linux

Azure Synapse Analytics (formerly known as Azure SQL Data Warehouse (SQL DW))

SQL Server on Amazon RDS databases

Azure SQL Database (SQL DB)

Azure SQL Managed Instance (SQL MI)

Azure SQL Multi-Factor Authentication (MFA)

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 the 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

Regular Tools Price

$499.90

$399.90

Compare Bundle Subscription

$319.95

$269.95

You Save

$199.95

$149.95

Buy Now

Choose an edition that suits you best

Schema Compare

Connectivity to Servers and Clouds

Integration

Sources to compare, synchronize, and deploy

Options

Analyzing differences and reporting changes

Automation

Data Compare

Connectivity to Servers and Clouds

Integration

Sources to compare, synchronize, and deploy

Options

Analyzing differences and reporting changes

Automation

Regular Tools Price

Compare Bundle Subscription

You Save