You'll receive

A bi-weekly newsletter

Exclusive discounts

Product update alerts

 
Compare data in live databases and backups
Perform row level recovery without restoring
Choose from 3 versions: Free, Dev, and Pro
Report on differences with advanced HTML reports
Compare huge databases quickly and without errors
Automate and schedule data migrations

Features

Row level recovery from backups

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

See next feature

SSMS integration

Initiate data comparison 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

See next feature

Object mapping

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

See next feature

Data filters

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

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

Reporting

Export the comparison results to several different types of HTML reports

See next feature

Data level Reports

Create HTML reports showing all data differences

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

Roadmap

Support for Script folder data source

Compare and synchronize databases directly against scripts in the folder

Support for Source control data source

Compare and synchronize databases directly against scripts in a source control system

Implement Schema mapping feature

Create custom mapping of schemas. If tables/views have different schemas in the source and the destination data sources, then Schema mapping allows specifying required mapping and tables/views will be automatically mapped

See our entire roadmap
ApexSQL Data Diff 2015 Released ApexSQL Data Diff 2015 R3 Q3 ApexSQL Data Diff 2015 R4 Q4
Comparison
Comparison options
Ignore computed column option
Ignore identity column option
Treat empty strings as null option
Ignore underscores in names option
Round floating types
Support for Script Folder data source
Support for Source Control data source
Implement Owner mapping feature
Synchronization
Implement drop unique option
GUI features
'Find' functionality for Data View grid
Exporting
Improved print report
Data comparison results in HTML reports
Comparison report in Microsoft Office Excel XML format
Performance and quality
Improved database/backup comparison performance
Improved synchronization script execution performance
Significantly improved generation synchronization script performance
CLI
Improved help output
Other
Integration with ApexSQL Diff (call from ApexSQL Data Diff)
Support for all Azure SQL Database V12 features
ApexSQL Data Diff 2015 Released ApexSQL Data Diff 2015 R3 Q3 ApexSQL Data Diff 2015 R4 Q4

Content

Versions

This product has Community, Dev and Pro versions

See version table
Data sources Community Dev Pro
Compare and synchronize SQL Server Express databases
Compare and synchronize SQL Azure databases
Compare and synchronize live databases
Compare and synchronize native or natively compressed database backups
Features
Compare and synchronize data directly from SSMS
Compare and synchronize data on FIPS compliant systems
Compare data in encrypted database objects
Granularly restore data down to the row level
Detect and resolve differences between data stored in FileTables and columnstore indexes
Synchronize data stored in SPARSE columns and FILESTREAMs
Leverage the increased memory limit and performance boosts in the x64 architecture
Compare data in tables without primary key or UNIQUE constraints using a custom comparison key
Create and export detailed reports to document the differences in your environments
Review the impact of the synchronization script before it is executed, including any warnings or messages
Select what will be compared and synchronized with advanced filtering
Create your own custom comparison keys
Build sophisticated filters to compare and synchronize specific data
Compare data in different SQL objects across environments using object mapping
Save your options to a project for instant re-execution
Automatically backup the destination database prior to synchronization
Full support for SQL Server 2014, 2012, 2008, 2005
Compare with SQL database backups without restoring
Augment the deployment script with your own pre or post synchronization scripts
Restore selected data from database backups
Command Line Interface
Value bundles
ApexSQL Developer
ApexSQL Universal
Price
FREE $399 $599
Download Buy now Buy now

Testimonials

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

11 ApexSQL developer tools

Priority support

1 year free support and upgrades

New products added for free

Combined 60% savings

For only $800 more