Compare and Sync SQL Server Databases

dbForge Data Compare for SQL Server is a powerful SQL comparison tool that easily copes with big data and supports native SQL Server backups. With dbForge Data Compare, you can tune flawless SQL database comparison, quickly analyze SQL data differences, compare static data against a version-controlled database, and smoothly synchronize SQL Server data with the convenient wizard.

Compare SQL Server databases to detect changes
Compare SQL Server backups with live databases
Analyze SQL data differences between two databases
Synchronize two out-of-sync SQL databases
Restore data of a particular table from the backup
Copy look-up data from development to production
Automate routine data sync tasks with command-line interface

Features

Supported Data Scripts Folder Support Data Comparison Setup Custom Mapping Comparison Results Management Export of Comparison Results Data Synchronization Routine Tasks Automation SSMS Integration

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

dbForge Data Compare for SQL Server - Supported Objects

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.

dbForge Data Compare for SQL Server - Scripts Folder Support

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.

dbForge Data Compare for SQL Server - Custom mapping

Comparison Results Management

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

Filter and sort objects in results.
View data differences for each pair of objects.
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.

dbForge Data Compare for SQL Server - Data Diffs Management

Export of 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

dbForge Data Compare for SQL Server - Data Comparison Reports

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.

Create accurate synchronization scripts.
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.

dbForge Data Compare for SQL Server - SQL 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.

dbForge Data Compare for SQL Server - Routine Tasks Automation

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.

I compared your product against several competing products as part of a consulting project for a client and found your product to be highly functional and well designed and at a price point well below competing software at a similar level. It fits nearly all of their needs and was a clear choice to recommend above the others.