You'll receive

Bi-weekly updates

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)


Source control integration

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

See next feature

Compare database backups

Compare SQL databases against backups without restoring

See next feature

SSMS integration

Compare SQL database schemas directly from SQL Server Management Studio

See next feature


Export SQL database 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 SQL 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 SQL 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 SQL scripts prior to execution

See next feature

Difference viewer

Quickly identify line level differences between compared SQL databases

See next feature

Schema mapping

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


Export improvements

Create improved print and HTML reports

SSIS package comparison

Compare SQL Server Integration Services packages


Create custom mapping of tables and columns

See our entire roadmap
ApexSQL Diff 2015 R3 Released ApexSQL Diff 2016 R1 Q1 ApexSQL Diff 2016 R2 Q2
Performance and quality
Improved database/backup comparison performance
Improved synchronization script execution performance
Mapping tables and columns
Compare SQL Server Integration Services packages
Improved print report
HTML reports for structure source and destination data sources
Comparison report in Microsoft Office Excel XML format
Packaging output format
Azure SQL Database V12 full support
SQL Server 2016 CTP3 support
SQL Server Management Studio 2016 CTP3 integration
SQL Server 2016 support
ApexSQL Diff 2015 R3 Released ApexSQL Diff 2016 R1 Q1 ApexSQL Diff 2016 R2 Q2


Advantages of ApexSQL Diff

This article describes key and unique features, as well as important advantages of ApexSQL Diff


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


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


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

Joris Laperre


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


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


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


ApexSQL Redgate®
Free Dev Pro Standard Pro
SQL Server editions
      Amazon RDS
      Proprietary schema snapshot
      Native or natively compressed database backup
      Script folder
      Source control project and label
      Integration services package 2016
      3rd party backup
      SQL script
      Direct execution against database (synchronization)
      Proprietary schema snapshot
      Database installer package (e.g. .NET executable, C# project) 2016
      Source control project or label (synchronization)
      SQL Server Management Studio (SSMS)
Reports and exports
      HTML reports
      XML export
      Excel export 2016 2016 2016
General features
      Character level object differences
      Impact analysis e.g. warnings and messages
      Schema mapping
      Visual filtering of schema objects
      Filterable difference codes
      Pre and post synchronization scripts
Source control
      Subversion Native Native
      Team Foundation Server Native Native
      SourceGear Vault Native
      Git Native CLI
      Perforce Native CLI
      Mercurial Native CLI
      Command line interface
      Built in SQL script editor
Use cases
      Automate schema snapshot archiving for change auditing
      Deploy object changes directly from source control label
      Restore selected objects from a database backup without restoring
      Perform a remote update via a Database installer package 2016
Free $399 $599 $495 $945

ApexSQL Diff 2015.03.0321

Redgate® SQL Compare 11.3.0

Comparison was conducted on October 27, 2015

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

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