For the best web experience, please use IE11+, Chrome, Firefox, or Safari

SQL data compare

ApexSQL Data Diff is a SQL Server development tool that can perform comparison and synchronization of data stored in tables or views, between different data sources. Data sources include SQL Server databases, backups, source control projects and script folders. ApexSQL Data Diff also supports data synchronization for SQL Azure databases and SQL Server on Amazon RDS.
An introduction to ApexSQL Data Diff 13:06

Benefits

  • Compare live DBs, backups, script folders and SC projects

  • Deploy a database directly from source control

  • Create custom pre and post processing scripts

  • Integrate with all popular SC systems e.g. Git, SVN

  • Automate and schedule database synchronizations

  • Initiate database comparison directly from SSMS and VS

  • Report results to HTML, XML and Excel

  • Create executable installation packages

Features

Row level recovery from backups

Compare SQL database backups without restoring. Granularly restore data down to the row level. Learn more

SSMS and Visual Studio integration

Compare SQL data directly from the Object Explorer and Server Explorer right-click context menus in SSMS and Visual Studio

Key-independent comparison

Use a custom comparison key to compare data in tables without a primary key or UNIQUE constraints. Learn more

Object mapping

Compare data in different SQL objects with different names and schemas using object mapping. Learn more

Schema mapping

Compare SQL objects with different users. Learn more

SQL data compare filters

Selectively limit what will be compared and synchronized with data level filtering. Learn more

Custom script support

Augment the deployment script with your own pre or post synchronization scripts

Extensive configuration options

Customize comparison and synchronization options

Reporting

Export SQL data comparison results to several different types of HTML reports. Learn more

Data level reports

Create HTML reports showing all data differences between two compared tables. Learn more

Excel report

Export the comparison results to Excel

Object filter editor

Build complex filters to compare and synchronize specific objects

Repeatable sessions

Save your settings to a project for re-execution of the same session

Native IDE

Use the built in SQL editor to review and edit scripts prior to execution

Source control integration

Including Git, Mercurial, Perforce, Subversion, and Team Foundation Server

Script folder

Compare data from local script folders against a database or source control project

Visual themes

Customize the visual appearance with interface themes. Learn more

Related Topics

Testimonials

Grayhouse, LLC

I’ve been very impressed thus far with the ApexSQL Diff tool. Using it has been a breeze and the responsiveness of the support staff has been amazing! I’m looking forward to delving into the API for automation.

Christian R. Ford CIO

Fiat Group Automobiles UK Ltd

ApexSQL Diff tools... time-saving, life-saving software.... I love it :)

Ben Joyce Fiat Group Automobiles UK Ltd

Horizons International

Microsoft Great Plains is a database that has over 1,000 tables and 11,000 stored procedures and a large amount of other objects contained in SQL. I have looked at many different products to show the differences between the different versions of GP and ApexSQL, in my opinion was the fastest. Since their new changes to ApexSQL Diff they've even surpassed their own record in how long it takes to compare the databases. I validate this because I didn't do an accurate timing 2 years ago but I'm pretty sure the comparison has gone from 10-15 minutes down to less than a few minutes. It's amazing how fast it really works!

Jaydel Gluckie .net Development Manager

Blue Frog Solutions Inc.

Thank you for the fine product your company delivers (ApexSQL Diff). I have caused several companies to purchase this during my career as a DBA as I find it to be the best at reconciling database structure, hands down. I have successfully activated the software and as usual am extremely happy with the upgrade

Chuck Fox Blue Frog Solutions Inc.

MicroLogix Information Systems, Inc.

Thank you for all the help! After working with ApexSQL Diff for so many years it is extremely encouraging to see your involvement in the direction of the products! I still remember when I first started using proc-blaster (many moons and employers ago)! The product line has come a long way since those days and I am encouraged by the direction the applications have gone. :) With each release you have made my life easier :)

Tom Bruinsma Vice President - Integration Services

Global Care Solutions

Keep up the good work by the way, I′m using 2 of your products on a daily basis. ApexSQL Diff rocks

Joris Laperre DBA

WDT Datentechnik GmbH, Germany

As your product offers the best set of features I’ve seen so far and your customer-service has fully convinced me (couldn't be better, keep it going like this) I’d like to order a license of ApexSQL Diff

Martin Schwier Proj. Manager

Bell Mortgage

ApexSQL Diff paid for itself in the first hour of using it. I synced 12 different databases to a common rev and man am I happy

Casey Kirt Project Manager

OffiCom

ApexSQL Diff is a great product. Keep on the good work

Kris Gilot Software Manager

Corobori WebDesign

Renewal installed working fine. Boy I missed ApexSQL Diff, I tried a bunch of other software lately and yours is the only I felt at ease with

Jean-Luc Praz Founder

Exabyte Development

ApexSQL Diff is indispensable to me to sync objects between databases, and especially between source control and production (enabling clear view of exact changes going into production) once amended objects are ready for deployment.

Robert Blomstrand Senior Database and .Net Developer Consultant

Kord Information Systems, LLC

I love the ApexSQL Diff tool it is an integral part of my update process, I use it to update customer databases to the latest format required by our software. I don’t know what I would do without it. It works every time and I’ve never had an issue.

Annette Kord CEO

ApexSQL Diff is part of the ApexSQL DevOps toolkit

ApexSQL Diff is part of the  ApexSQL DevOps toolkit

Get started now

Compare SQL data from live databases, scripts, backups and source control.