dbForge Compare Bundle for SQL Server Features Overview

dbForge Compare Bundle consists of two separate SQL tools - Data Compare and Schema Compare. Each of the tools has two editions: Standard and Professional. Data Compare is a powerful tool to compare massive volumes of data that saves a lot of time and efforts on synchronizing them. You can also use it to identify database changes, restore damaged data, or update the database content from a backup or a scripts folder. Schema Compare is a robust tool for comparing and synchronizing object and schema differences that eliminates hours of error-prone manual work. With the help of the tool, you can work with live SQL Server databases, snapshots, scripts folders, and native backups, as well as generate deployment scripts, analyze differences, etc.

dbForge Compare Bundle for SQL Server can be integrated into SSMS thus allowing you to compare and sync SQL data and schema differences in a visual and familiar interface.

Comparison of incoherent databases

When you start a new schema or data comparison, the tools automatically map schemas, tables, objects, and columns. However, if data sources differ, they cannot be mapped automatically. Still, you can customize the mapping in the wizards:

Schema Mapping: Set mapping options if you compare objects of different schemas.
Table Mapping: Map a source table with several target tables.
Column Mapping: Map source and target columns with different names.

Learn More

Comparison of custom query results

The Custom Query feature provides more agility to data comparison and synchronization. Building custom queries allows you to adjust comparison operations up to your needs and project goals. To achieve this, on the Mapping page, click Custom query and enter the query in the Query SQL field. Then, you need to check source and target objects and start mapping of the query.

After the comparison is done, the result outputs to a .dcomp file displaying differences in objects.

Learn More

Support for schema objects

Schema Compare supports multiple schema objects for comparison and synchronization, for example:

Tables
Views
Sequences
Procedures

Learn More

Customization of data and schema comparisons

Schema and Data Compare provide multiple visual options to adjust the process of data and schema comparison to meet your requirements and project objectives. Options allow you to exclude/include properties, structures, objects, and data from comparison and synchronization.

Learn More

Customization of data and schema comparisons

Management of comparison results

The tools output the comparison results to the comparison document so that further you can deploy them to the target database. In the document, you can perform different operations on data. For example, you can view DDL of data differences, filter, group, and sort objects, generate a comparison report in the HTML, Excel, or CSV file formats, search for data, hide unmodified columns, etc.

Learn More

Smart sync

After you have selected the objects for deployment, you can run the synchronization. The wizard allows you to customize the synchronization process to suit your needs. For example, you can generate an update script for peer review, synchronize a database directly with a target database, or create a *.bat file to automate database deployment from the command line.

The tool automatically generates a sequence of updates according to the correct order of synchronization of dependent objects and a list of warnings about the issues, which you may face during the synchronization.

Routine tasks automation

Data Compare and Schema Compare allow automating and scheduling database comparison and synchronization tasks from the command line.

In the Command Line Wizard built into the tools, you can create a .bat file with the script that contains project’s comparison and synchronization settings. Then, you can run it in any Task Scheduler to start the database comparison and synchronization at the defined date and time.

Learn More

DevOps automation

Schema Compare as part of the DevOps workflow is aimed at simplifying the synchronization of the database with the scripts folder, put under the source control.

After you set comparison options in the New Schema Comparison wizard, you will see all the changes to the database objects in the Comparison Results document, so that you can synchronize them with the scripts folder.

Learn More

SSMS integration

Both Schema and Data Compare tools can be easily integrated with Microsoft SQL Server Management Studio so that you can perform data and schema comparison and synchronization tasks directly from the IDE you are used to. In addition, you can compare and synchronize a database, a scripts folder, or a database version from source control as the source and target.