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

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.

Data Compare
is a part of Compare Bundle

Find out more

Leading companies choose dbForge Data Compare

Kenworth
International paper
Wells fargo
Paccar
Nordstrom

What people say about Data Compare

More testimonials Your testimonials
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. Kudos on a quality piece of software.
Kevin Locke
Digital engine software
First of all thanks for providing such great products on SQL Server and making life easier. I am a freelance developer, having good experience in developing software products with optimal performance.
Santhosh
Freelance developer

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 SQL Tools 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

Takes part in DevOps Automation

Use Data Compare along with dbForge DevOps Automation for SQL Server to extend DevOps practices to SQL Server databases. The solution helps optimizing productivity, reducing database release costs, and making the overall workflow consistent and safe.

Explore
dbForge DevOps Automation for SQL Server

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.