You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Compare data in live DBs, backups and SC projects
Perform row level recovery without restoring
Community, Standard, and Professional editions
Compare huge databases quickly and without errors
Automate and schedule data migrations
Initiate database compares directly from SSMS
Export results to HTML, CSV and Excel
Create executable installation packages
Integrate with all popular SC systems e.g. Git, SVN
Deploy data changes directly from a source control label


Row level recovery from backups

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

See next feature

SSMS integration

Compare SQL database data directly from SQL Server Management Studio

See next feature

Key-independent comparison

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

See next feature

Object mapping

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

See next feature

Schema mapping

Compare SQL objects with different users Learn more

See next feature

Data filters

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

See next feature

Custom script support

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

See next feature

Extensive configuration options

See next feature


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

See next feature

Data level reports

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

See next feature

Excel report

Export the comparison results to Excel

See next feature

Object filter editor

Build complex filters to compare and synchronize specific objects

See next feature

Repeatable sessions

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

See next feature

Native IDE

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

See next feature

Source control integration

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

See next feature

Advantages of ApexSQL Data Diff vs. Visual Studio®

This article describes features which are available in ApexSQL Data Diff and which don’t exist in Visual Studio®

What’s new in ApexSQL Data Diff 2016 R2

This article shows what new features and enhancements have been added in the new version of ApexSQL Data Diff 2016 R2

Automatically compare and synchronize SQL Server data

This article describes how to use ApexSQL Data Diff to set all synchronization options, map tables and columns with different names, create your own keys for comparison in the GUI and schedule it to run unattended

Synchronize SQL Server databases in different remote sources

This article describes how to synchronize SQL Server databases on remote locations with a SQL Server database in the datacenter using ApexSQL Data Diff

SQL Server bulk copy and bulk import and export techniques

This article explains how to copy large amounts of data from one table or set of tables to other databases

How to compare SQL Server database tables with different names

This article describes how to use the Object mapping feature to compare SQL Server database tables with different names

ApexSQL Data Diff Command Line Interface (CLI) switches

This article explains the ApexSQL Data Diff CLI switches, and their usage through the examples

See more
ApexSQL Redgate ®
Community Standard Professional Standard Pro
SQL Server editions
      Azure SQL Database
      SQL Server on Amazon RDS
      Native or natively compressed database backup
      Script folder 2017 R1
      Source control project and label
      3rd party backup
      Direct execution against database (synchronization)
      Source control project or label (synchronization)
      SQL script
      Database installer package (e.g. Executable installer, C# solution)
      SQL Server Management Studio (SSMS)
Reports and exports
      CSV export
      Excel export
      HTML report
      XML export
General features
      Custom comparison keys for tables without PK or Unique constraints
      Data compare filters
      Impact analysis e.g. warnings and messages
      Object mapping
      Schema mapping
      Source control integration
      Pre and post synchronization scripts
Supported source control systems
      Subversion Native Native
      Team Foundation Server Native Native
      Git Native CLI
      Mercurial Native CLI
      Perforce Native CLI
      Command line interface
      Source control label support
      Built in SQL script editor
      Save project as batch file
Use cases
      Compare database with source control project
      Compare with SQL database backups without restoring
      Row level recovery from a database backup
      Perform a remote update via a Database installer package
Free $399 $599 $495 $745

ApexSQL Data Diff 2016.03

Redgate® SQL Data Compare 11.6.11

Comparison was conducted on October 11, 2016

Disclaimer: All product and company names are trademarks or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates


Source control integration

Compare and synchronize databases directly against data in source control projects and labels

New GUI themes

Three new GUI themes: White, Colorful and Dark

Support for Script folder data sources

Compare and synchronize databases directly against scripts in a folder

See our entire roadmap

The roadmap does not show maint only releases

ApexSQL Data Diff 2016 R1 Released ApexSQL Data Diff 2016 R2 Released ApexSQL Data Diff 2016 R3 Released ApexSQL Data Diff 2016 R4 Released ApexSQL Data Diff 2017 R1 Q2
Performance and quality
Improved database/backup comparison performance
Improved synchronization script execution performance
Significantly improved generation synchronization script performance
Schema mapping feature
Support for Source control data source
Support for Script folder data source
Create rollback script for destination database before synchronization
Create script folder backup for destination script folder or source control before synchronization
Packaging output format
Improved HTML reports
Export CLI help as HTML
17 new return error codes
Return error codes switch
Package options switches
Warnings handling switch
Ignore new objects switch
Silent switch
Improved output messages:
Comparison summary
Warnings output
Synchronization summary
Changes output
Schema mapping switch
Logging level switch
Sound playing switch upon finished operation
No differences detected return code
Return error code on equal results switch
Comparison summary output switch
Synchronization warnings output switch
Synchronization summary output switch
Create rollback script for destination dababase before synchronization switch
Destination rollback script file name switch
Create script folder backup for destination script folder or source control before synchronization switch
Destination script folder backup path switch
SQL Server 2016 support
Azure SQL Database V12
Save project as batch file
SQL Server Management Studio 2016 integration
SQL Server on Amazon RDS support
SQL Server Management Studio v17.0 RC1 integration
GUI themes
ApexSQL Data Diff 2016 R1 Released ApexSQL Data Diff 2016 R2 Released ApexSQL Data Diff 2016 R3 Released ApexSQL Data Diff 2016 R4 Released ApexSQL Data Diff 2017 R1 Q2


We have fully integrated ApexSQL Diff and ApexSQL Data Diff into our design, integration/ performance testing, and production release SDLC. The ApexSQL tools have tremendously increased our confidence level on the integration of these systems and the veracity of our product release cycles. ApexSQL Data Diff allowed us to proof test the automation of a ETL process against the long standing manual process that was in use in production, and when that system goes into full production, will save our company hundreds of thousands of dollars over the next few years, and millions in the years to come

William E. Saxon, Jr.

T Consultant - Application Development

Nationwide Better Health

We are a startup HIS company that provides a hosted solution for hospital Clinical Diagnostic Information. The requirements are such that we needed a comprehensive Structure and Data Diff/Update tool for our sometimes complex updates. ApexSQL Diff and ApexSQL Data Diff have been nothing short of miraculous in performing diffs and providing upgrade scripts. Even a difficult update with table, column and key name changes showed a lot of intelligent programming went into these tools. Highly recommended

Martin Bradburn

Principle DBA

ChartWise Medical Systems

I have to say, the purchase of ApexSQL Diff and ApexSQL Data Diff has to be among the best (if not *the* absolute best) investments my company ever made for our database needs. Our flagship product runs on each client's site against a series of databases - 4 to be exact; so when we add new functionality to the product we invariably have a fair amount of updates to one or more of these databases. We generally deploy our updates in small batches as soon as new features get out of QA so we never really needed to come up with an elaborate deployment scheme. We would simply generate a few SQL scripts to create or alter SQL objects and populate data as needed. All that changed recently. A major new update to our product was completed, comprising nearly two years’ worth of effort. Extensive changes were made to each of the four databases, with one of them more than doubling in size (amount of SQL objects). The changes were, of course, varied: new tables, stored procedures, entity relationships, rules, etc... as well as scores of updates to existing objects. Included among the changes were pre-populated lookup tables containing thousands of rows of data. Now we were faced with the challenge of how to deploy this beast. Could we write deployment scripts to update our existing clients? Of course. But how long would that take? Hours? Days? Sure, Enterprise Manager could generate the DDL to create our new objects, but it doesn't take dependencies into account; the manual intervention required to ensure our deployment scripts would create SQL objects in the proper sequence would only add to the overall time required. We were under an extremely tight deadline to deploy our changes so I tried the combination of ApexSQL Diff and ApexSQL Data Diff to apply our changes. Using a test server first, I used ApexSQL Diff to sync against my development server and was amazed to find that within MINUTES I had a completely synced database. No searching for all of the objects I needed to synchronize, no update script to write, and no dependency order issues to worry about - ApexSQL Diff took care of everything for me! Best of all, it also provided me with an update script that I could save and archive in source control. Using ApexSQL Data Diff next, I was able to sync as much or as little of my data differences as I needed. I couldn't have asked for better results! Your tools literally paid for themselves the very first time I used them! I whole-heartedly recommend ApexSQL Diff and ApexSQL Data Diff to anyone with any serious SQL Server synchronization needs

Rich Ackerson

I am with my third company using your ApexSQL tools. Brian, over the years it I have always appreciated that you see and respond personally to the Email & Forum traffic ApexSQL Diff still rocks and splitting out ApexSQL Data Diff was definitely a step in the right direction

David M. Carpenter

Senior Application Developer

CareMedic Systems Inc.

Save a bundle

ApexSQL Data Diff is included in ApexSQL Developer

14 ApexSQL developer tools

Priority support

1 year free support and upgrades

New products added for free

Combined 75% savings