You'll receive

A bi-weekly newsletter

Exclusive discounts

Product update alerts

 
Compare live DBs, backups, scripts and SC projects
Deploy a database directly from source control
Choose from 3 versions: Free, Dev, and Pro
Integrate with all popular SC systems e.g. Git, SVN
Automate and schedule database synchronizations
Initiate database compares directly from SSMS
Report results to HTML, XML and (soon) Excel
Create executable .NET packages (soon)

Features

Source control integration

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

See next feature

Compare database backups

Compare databases against backups without restoring

See next feature

SSMS integration

Compare SQL databases directly from SQL Server Management Studio

See next feature

Reporting

Export comparison results to HTML

See next feature

Accurate dependencies

Recognize all object interdependencies, even those that even SQL Server itself fails to identify, to ensure perfect sync scripts every time

See next feature

Schema snapshots

Build a continuous audit trail of all schema changes through schema snapshots. Create snapshots nightly with scheduled jobs

See next feature

Pre-impact analysis

Review the impact of the synchronization script before it is executed, including warning levels and messages

See next feature

Database builds

Deploy scripts saved in a file or under source control to a new or existing database

See next feature

Repeatable sessions

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

See next feature

Custom script support

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

See next feature

Native IDE

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

See next feature

Difference viewer

Quickly identify line level differences

See next feature

Schema mapping

Compare objects with different users

See next feature

Transparent decryption

Compare encrypted objects

See next feature

Object filters

Selectively limit what will be compared and synchronized with advanced, visual filtering

See next feature

Roadmap

Export improvements

Create improved print and HTML reports

Microsoft Office Excel XML format

Export comparison results to Excel

Mapping

Create custom mapping of tables and columns

See our entire roadmap
ApexSQL Diff 2015 Released ApexSQL Diff 2015 R2 Released ApexSQL Diff 2015 R3 Q3 ApexSQL Diff 2016 Q4 ApexSQL Diff 2016 R2 Q1
Comparison
Support for Mercurial source control system
Support for Perforce source control system
Mapping tables and columns
Comparison options
Ignore next filegroups in partition scheme
Ignore WITH NOCHECK
Ignore database and server name in synonyms
Ignore authorization
Ignore database properties
Ignore change tracking
Compare database properties (extended properties, etc)
Synchronization
"Use DROP/CREATE statements instead of ALTER for different tables" option
Exporting
Improved print report
HTML reports for structure source and destination data sources
Comparison report in Microsoft Office Excel XML format
Performance and quality
Improved database/backup comparison performance
Improved synchronization script execution performance
CLI
Improved help output
Other
Integration with ApexSQL Diff (call from ApexSQL Data Diff)
Support for all Azure SQL Database V12 features
Support for SQL Server 2016
Support for all SQL Server 2016 features
Integration to SQL Server Management Studio 2016
ApexSQL Diff 2015 Released ApexSQL Diff 2015 R2 Released ApexSQL Diff 2015 R3 Q3 ApexSQL Diff 2016 Q4 ApexSQL Diff 2016 R2 Q1

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 SQL Server 2014, 2012, 2008, and 2005 databases
Compare and synchronize ApexSQL snapshots
Compare and synchronize native or natively compressed database backups
Compare and synchronize script folders
Compare and synchronize directly from source control
Features
Compare and synchronize objects directly from SSMS
Compare and synchronize schema on FIPS compliant systems
Compare and synchronize encrypted database objects
Identify line level object differences using syntax highlighting
Create reports to document the differences in your environments
Review the impact of the synchronization script before it is executed including any warnings or messages
Ensure error-free migrations using proprietary dependency analysis algorithms
Compare objects across environments using schema mapping
Select the objects to be compared and synchronized with visual filtering
Identify all object interdependencies, even those that even SQL Server itself fails to recognize
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
Augment the deployment script with your own pre or post synchronization scripts
Deploy the latest object changes directly from source control
Create a live database from scripts
Restore selected objects from database backups
Command Line Interface
Value bundles
ApexSQL Developer
ApexSQL Universal
Price
FREE $399 $599
Download Buy now Buy now

Testimonials

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

Ben Joyce

Fiat Group Automobiles UK Ltd

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

Horizons International

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

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.

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

MicroLogix Information Systems, Inc.

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.

Thanks! Great customer service! I really appreciate your help and quick response. I had never used ApexSQL Diff before and in 5 minutes I had my scripts ready to upgrade my other database with both new objects and data. ApexSQL Diff was very intuitive to use and worked like a charm. I can't believe how much time I wasted previously generating upgrade scripts by hand

Tempe Lampe

Development Manager

Water & Gas AMI Solutions

I just wanted to thank you both for all of your help--- particularly with such short notice! I am looking forward to using your new products. The ApexSQL Edit/Diff are some of the best tools in my arsenal. I assure you that your hard work and sweat are much appreciated!

David Hanson

RITIX Inc.

First I would like to thank you for creating the most comprehensive and fully featured SQL objects comparison tool I have ever used. I went through almost all its features. I like it SO MUCH because one of the benefits of using this tool is that it provides me not only high efficiency but also tremendous reliability to the large database migration processes. I believe that the HIGH level of quality and efficiency of doing database migrations with its help would NEVER be achieved by any other means we used to utilize

George Zhang

Board of Equalization, California

I have been using ApexSQL Diff and absolutely love it. Fantastic product well

Ben Jackson

Senior Developer

Sage Technology

So far, ApexSQL Diff is the only SQL diff program that actually works with SQL2005 CTE's in stored procedure

Greg Gillis

Development Manager, Data Warehouse Analyst

Datamark

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

Global Care Solutions

Thanks for the feedback Brian - I have liked the UI and support for your product the best, I should be parting with my cash very soon ... Thanks for the support ...

Patrick McCarthy

Developer

JDA Software Group, Inc

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

WDT Datentechnik GmbH, Germany

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

Bell Mortgage

Project Manager

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

Kris Gilot

Software Manager

OffiCom

I downloaded your excellent software to compare data bases and schemas and it worked great. The UI is very easy to use.

Alonso Rojas

Sr. Net Consultant

4th Source

Save a bundle

ApexSQL 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