Compare and Sync
SQL Server Databases

Data Comparison Result Management

The Data Comparison document provides a clear display of the comparison results and includes a set of features for effective management of the data differences.

• View data differences for each pair of objects.
• Filter and sort objects in results.
• Quickly navigate through SQL Server data differences.
• Perform full-text data search.
• View number of changes per column.
• Hide unmodified columns to simplify analysis.
• Select arbitrary columns for display.

Supported Data

With dbForge Data Compare for SQL Server, you can use SQL Server data of the following objects as Source and Target for data comparison and synchronization:

• SQL Server table data
• Data from SQL Server Views
• Data of the database backups
• Custom queries
• Static data from the scripts folder
• Table data of SQL Azure Cloud
• Table data of SQL Server installed on Linux

Scripts Folder Support

Data Compare for SQL Server compares not only database backups, tables, and views, but it also allows comparing static data from a local scripts folder against a database of a source control project.

You can specify an existing scripts folder, or create the one from scratch and set up the folder structure.

Data Comparison Setup

• Include SQL tables or views into comparison by mask or individually.
• Exclude objects from comparison by mask or individually.
• Ignore columns by mask (e.g. don't compare ModifiedDate column in all tables).
• The Float types rounding option.
• The Ignore Case and Ignore Trailing Spaces options for string comparison.
• The LOB comparison options.
• The WHERE filter for limiting the compared data (e.g. in extra large tables).

Custom Mapping

Along with automatic mapping, dbForge Data Compare for SQL Server provides advanced options for custom mapping at the levels of schemas, objects, and columns.

• Object Mapping allows comparing tables and views with different names and column set.
• Map one table in source with two or more tables in target (useful when table was split).
• Column Mapping allows mapping columns that have different names and specifying the comparison key and the list of columns to be compared.
• The Custom Query feature allows comparing a table with a query result.
• Schema mapping helps mapping tables and views with unequal owners.

Export of Data Comparison Reports

• Generate SQL Server data comparison report in the Excel, HTML, and CSV file formats
• Include actual data into report
• Report on selected objects only

Data Synchronization

Data Synchronization Wizard will guide you through each step of the diffs deployment. The wizard includes a bunch of options that make SQL Server data synchronization safe and flawless.

• Generate T-SQL synchronization script for the deployment or review.
• Migrate individual records, groups of records, or all SQL Server data differences.
• Toggle synchronization direction to apply data changes to both databases.
• Rollback changes on error.
• Warnings on possible problems prior to SQL Server data synchronization.

Routine Tasks Automation

dbForge Data Compare for SQL Server provides several ways to automate routine SQL Server data comparison and sync tasks and save tons of time and efforts.

• Save the comparison project settings for the future use.
• Use the command-line interface or PorwerShell for automatic routine synchronizations.
• Save comparison and sync settings as a command-line execution file (.bat) and run it whenever you need.
• Schedule .bat file execution on a schedule with Windows Scheduler.

SSMS Integration

The tool easily integrates into Microsoft SQL Server Management Studio and brings safe and convenient SQL Server data comparison and synchronization functionality right to your favorite IDE.