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

Features

SQL database backups comparison

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

Reporting

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

How to automatically keep two SQL Server database schemas in sync

This article describe how a system including a SQL Server database schema compare tool, along with some PowerShell and a scheduler can keep the QA database in sync and up to date, and run automatically and unattended

How to build a “smart” SQL Server Data dictionary

This article explains how to create a smart data dictionary using XML schema change exports from ApexSQL Diff

How to automatically monitor a SQL Server database for schema changes and create an audit log

This article explains how to set up a simple yet powerful system to monitor an unlimited number of databases, that can be connected to via the workstation client that ApexSQL Diff is installed on

How to keep a source control repository updated with the latest SQL Server database changes

This article describes how a system including a SQL Server database schema compare tool, along with some PowerShell and a scheduler can keep a source control repository in sync and up to date, in near real time, and run automatically and unattended

Compare SQL Server database schemas automatically

This article describes how to automate comparison and synchronization of SQL Server database schemas using ApexSQL Diff

How to version and audit schemas and rollback changes with schema snapshots

This article describes method of database versioning, where the whole database schema is saved to a snapshot file, which can be reused later on to recreate the captured state of a database

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
      Express
      Standard
      Enterprise
Cloud
      Azure SQL Database
      SQL Server on Amazon RDS
Inputs
      Proprietary schema snapshot
      Native or natively compressed database backup
      Script folder
      Source control project and label
      SSIS packages
      3rd party backup
Outputs
      SQL script
      Direct execution against database (synchronization)
      Proprietary schema snapshot
      Source control project or label (synchronization)
      Database installer package (e.g. Executable installer, C# solution)
Integration
      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
      Projects
      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
Other
      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
Price
Free $399 $599 $495 $745

ApexSQL Diff 2017.01

Redgate® SQL Compare 12.2.0


Comparison was conducted on March 2, 2017

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

Roadmap

New GUI themes

White, colorful and dark

SSIS package comparison

Compare SQL Server Integration Services packages

Mapping

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 Released ApexSQL Diff 2017 R2 Released ApexSQL Diff 2017 R3 Q2
Performance and quality
Improved database/backup comparison performance
Improved synchronization script execution performance
Comparison
SQL Server Integration Services package comparison
Mapping tables and columns
Comparison options
Ignore lock escalation property of tables
Ignore brackets
Ignore case for text objects
Ignore default column collations
Ignore DML triggers
Ignore semicolons
Ignore tSQLt
Synchronization
Create snapshot of destination database before synchronization
Create rollback script for destination database before synchronization
Create script folder backup for destination script folder or source control before synchronization
Copy warnings and actions
Direct synchronization of saved data sources
Synchronization options
Add constraints and keys to tables using with nocheck
Force column order
Exporting
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)
XML export customization options
Export schema differences to SQL and database
Export warnings and actions
Export dependencies
Export synchronization results
GUI features
Script difference panel options:
Change colors
Increase/Decrease font size
Find
Word wrap
Create new database
Play a sound upon finished operation
CLI
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
No differences detected return code
Return error code on equal switch
XML export customization options switch
Create snapshot of destination database before synchronization switch
Destination snapshot file name 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
Comparison summary output switch
Synchronization warnings output switch
Synchronization summary output switch
Differential backup set switches
Integration services connection switches:
Integration services packages switches
Package files switches
SQL Server packages switches
SSISDB catalog packages switches
SSIS project file switches
Server name for the comparison results output database
Login for server for the comparison results output database
Login’s password for server for the comparison results output database
Database name for the comparison results output database
New values for the output type switches: SQL compare results and database
Other
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
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 Released ApexSQL Diff 2017 R2 Released ApexSQL Diff 2017 R3 Q2

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

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

Founder

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