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. The tool integrates with SQL Server Management Studio.

  • Detect data changes between live databases, backups or script folders
  • Generate T-SQL scripts to update one database with content from another
  • Restore damaged or missing data to a single row from a native backup
  • Copy lookup data from development databases to staging or production
  • Deploy to SQL Server, SQL Azure, and SQL Server on Amazon RDS
  • Automate routine data sync tasks with command-line interface
  • Export data comparison results to CSV, HTML, and Excel

Features

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

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

Data Compare is part of Compare Bundle

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.
Kevin Locke, Digital Engine Software

Get Started with dbForge Data Compare at no cost

Download a FREE 30-day trial and start saving time spent on your database deployments today.

Download for free

Buy multi-user licenses with substantial discount

If you have any questions about the tool and its purchase options, feel free to contact our sales team.

Purchase now

Try Developer Bundle with Data Compare included

Sync schemas, deploy from version control, write SQL, and more with our mega pack of SQL Server tools.

Find out more