You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Tools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server
Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server
Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server
Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server
Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server
Spotlight Cloud hosted SQL Server monitoring and diagnostics
LiteSpeed High-speed SQL Server backup, compression and restore
Compare live DBs, backups, script folders and SC projects
Deploy a database directly from source control
Create custom pre and post processing scripts
Integrate with all popular SC systems e.g. Git, SVN
Automate and schedule database synchronizations
Initiate database comparison directly from SSMS and VS
Report results to HTML, XML and Excel
Create executable installation packages


SQL database backups comparison

Compare SQL databases against backups without restoring. Learn more

See next feature

SSMS and Visual Studio integration

Compare SQL schemas directly from the Object Explorer and Server Explorer right-click context menus in SSMS and Visual Studio

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

Visual themes

Customize the visual appearance with interface themes. Learn more

See next feature

SSIS packages comparison

Compare SSIS packages and export package difference results

See next feature

ApexSQL Diff 2018 - Screen shot tour

This article describes features of ApexSQL Diff through the screen shots

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 describes 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®
Professional Standard Pro
SQL Server version
      SQL Server 2005
      SQL Server 2008 - 2019
SQL Server editions
      Azure SQL Database
      Amazon RDS for SQL Server
      SQL Server Management Studio (SSMS)
      Visual Studio
      Native or natively compressed database backup
      Schema snapshot
      Script folder
      Source control project (latest version)
      SQL Server database
      3rd party backup and project
      Source control project (changeset)
      Source control label
      SSIS packages
      Direct execution against database (synchronization)
      Schema snapshot
      Script folder (synchronization)
      SQL script
      Source control project (latest version synchronization)
      Source control project (changeset synchronization)
      Database installer package (e.g. Executable installer, C# solution)
      Differential snapshot
      Source control label (synchronization)
Reports and exports
      Excel export
      HTML reports
      XML export
      Export to a database
      Export to a SQL script
      Character level object differences
      Impact analysis e.g. warnings and messages
      Schema mapping
      Transparent decryption of encrypted objects
      Visual filtering of schema objects
      Comparison and synchronization of sensitivity classifications
      Comparison and synchronization of edge constraints
      Examine differences using the script summary view
      Ignore sensitivity classifications on fields
      Filterable difference codes
      SSIS package comparison
Pre-sync actions
      Backup destination database
      Create snapshot
      Error-free synchronization scripts
      Include dependent database objects
      Backup Azure SQL managed destination database
      Create rollback script
      Create script folder backup
      Pre and post synchronization scripts
Source control system support
      Subversion Native Native
      Team Foundation Server Native Native
      Git Native CLI
      Mercurial Native CLI
      Perforce Native CLI
      Azure Active Directory authentication
      SQL Server on Linux
      Securely saved logins
      Create a new database
      SQL graph support
      Temporal tables support
      History retention period option
      Integrated SQL script editor
      Save project as automation script
Use cases
      Automate comparison and synchronization of SQL Server database objects with a shared script folder
      Automate pulling SQL Server database objects from a shared script folder to a local database
      Automate schema snapshot archiving for change auditing
      Automate SQL Server database schemas synchronization
      Compare schemas from SSMS
      Narrow schema comparison and synchronization to affected objects only
      Restore selected objects from a database backup without restoring
      Deploy object changes directly from source control label
      Perform a remote update via an executable installation package
      Windows Command line interface
      Linux Command line interface
      GUI themes
      High DPI and 4K resolution support
      Host aware theme adoption
      Microsoft standard iconography, colors and other visual effects

ApexSQL Diff 2019.01

Redgate® SQL Compare

Comparison was conducted on January 24, 2020

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


I’ve been very impressed thus far with the ApexSQL Diff tool. Using it has been a breeze and the responsiveness of the support staff has been amazing! I’m looking forward to delving into the API for automation.

Christian R. Ford


Grayhouse, LLC

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

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.

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

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


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

Jean-Luc Praz


Corobori WebDesign

ApexSQL Diff is indispensable to me to sync objects between databases, and especially between source control and production (enabling clear view of exact changes going into production) once amended objects are ready for deployment.

Robert Blomstrand

Senior Database and .Net Developer Consultant

Exabyte Development

I love the ApexSQL Diff tool it is an integral part of my update process, I use it to update customer databases to the latest format required by our software. I don’t know what I would do without it. It works every time and I’ve never had an issue.

Annette Kord


Kord Information Systems, LLC

ApexSQL Diff is one of the best and well supported time and effort saver when it comes to database schema management.

Shukhrat Nekbaev

.NET Developer

Civil Air Patrol had a need for an easy to use, quality tool to solve a Microsoft SQL data/schema synchronization issue. ApexSQL by far was the tool for us. It allowed us to quickly complete the project and allowed us to incorporate automation to allow us to keep that data in sync. This is an awesome tool with excellent customer service to support it. Thanks ApexSQL for helping us out!

Steve Groner

Riverside Senior SQ 5

Civil Air Patrol, Pacific Region

ApexSQL Diff is part of the

ApexSQL DevOps toolkit

© 2022 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy