You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Compare live DBs, backups, script folders and SC projects
Deploy a database directly from source control
Community, Standard, and Professional editions
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 Excel
Create executable installation packages


Compare SQL database backups

Compare SQL databases against backups without restoring Learn more

See next feature

SSMS integration

Compare SQL database schemas directly from SQL Server Management Studio Learn more

See next feature


Export SQL database comparison results to HTML Learn more

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 Learn more

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 Learn more

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 Learn more

See next feature

Transparent decryption

Compare encrypted SQL objects

See next feature

Object filters

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

See next feature

Source control integration

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

See next feature

Advantages of ApexSQL Diff

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

What’s new in ApexSQL Diff 2016 R2

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

Compare SQL Server database schemas automatically

This article describes how to schedule ApexSQL Diff to compare all database objects, check for dependencies and script them along with objects, make sure scripts are executed in the correct order, and create a full database backup before the synchronization

How to compare SQL databases in SSMS

This articles shows how to use ApexSQL Diff to compare and synchronize SQL databases directly in SSMS, including backups and versions from source control

Create a database script from a backup without restoring it

This article describes how to use ApexSQL Diff to create a database script from a backup without restoring it

How to recover a specific dropped object

This article describes how to use ApexSQL Diff to create a DDL script directly from the database backup only for objects that are to be restored

ApexSQL Diff Command Line Interface (CLI) switches

This article explains the ApexSQL 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
      Proprietary schema snapshot
      Native or natively compressed database backup
      Script folder
      Source control project and label
      3rd party backup
      SQL script
      Direct execution against database (synchronization)
      Proprietary schema snapshot
      Database installer package (e.g. Executable installer, C# solution)
      Source control project or label (synchronization)
      SQL Server Management Studio (SSMS)
Reports and exports
      Excel export
      HTML reports
      XML export
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
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
      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
Free $399 $599 $495 $945

ApexSQL Diff 2015.03

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


New GUI themes

White, colorful and dark

SSIS package comparison

Compare SQL Server Integration Services packages


Create custom mapping of tables and columns

See our entire roadmap

The roadmap does not show maint only releases

ApexSQL Diff 2015 R3 Released ApexSQL Diff 2016 R1 Released ApexSQL Diff 2016 R2 Released ApexSQL Diff 2017 R1 Q1 ApexSQL Diff 2017 R2 Q2
Performance and quality
Improved database/backup comparison performance
Improved synchronization script execution performance
SQL Server Integration Services package comparison
Mapping tables and columns
Comparison options
Ignore brackets
Ignore DML triggers
Ignore semicolons
Ignore tSQLt
Create snapshot before synchronization
Create rollback script before synchronization
HTML structure reports for source and destination data sources
Comparison report in Microsoft Office Excel XML format
Packaging output format (C# solution and Executable installer)
Export schema differences to SQL and database
Improved HTML reports
Export warnings and actions
Export dependencies
Export synchronization results
Export CLI help as HTML
17 new return error codes
Return error codes switch
Package options switches
Warnings handling switch
Silent switch
Ignore new objects switch
Ignore invalid objects switch
Improved output messages:
Comparison summary
Warnings output
Synchronization summary
Changes output
Logging level switch
Sound playing switch upon finished operation
Azure SQL Database V12
SQL Server 2016 support
SQL Server Management Studio 2016 integration
SQL Server on Amazon RDS support
Save project as batch file
Three new GUI themes
SQL Server Management Studio v17.0 RC1 integration
ApexSQL Diff 2015 R3 Released ApexSQL Diff 2016 R1 Released ApexSQL Diff 2016 R2 Released ApexSQL Diff 2017 R1 Q1 ApexSQL Diff 2017 R2 Q2


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

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

Jean-Luc Praz


Corobori WebDesign

Save a bundle

ApexSQL 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