ApexSQL Diff

SQL Server schema compare

Compare and synchronize SQL Server database schemas

?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

Compare SQL database backups

Compare SQL databases against backups without restoring

SSMS integration

Compare SQL database schemas directly from SQL Server Management Studio

Reporting

Export SQL database comparison results to HTML

Accurate dependencies

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

Schema snapshots

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

Pre-impact analysis

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

Database builds

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

Repeatable sessions

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

Custom script support

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

Native IDE

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

Difference viewer

Quickly identify line level differences between compared SQL databases

Schema mapping

Compare SQL objects with different users

Transparent decryption

Compare encrypted SQL objects

Object filters

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

Source control integration

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

System requirements

Hardware requirements Dual Core 2.0 GHz CPU

 3 GB memory

 94 MB disk space 

SQL Server Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005

 Azure SQL Database, SQL Server on Amazon RDS 

Add-in integration SQL Server Management Studio 2016, 2014, or 2012

OS Windows Vista/Server 2008 and above

Required  Microsoft .NET Framework 4.5 

Note Native support for the x64 architecture

Native support for Git, Mercurial, Perforce, Subversion, and Team Foundation Server

Testimonials

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

Ben Joyce

Fiat Group Automobiles UK Ltd

Compare

 

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   ?  ?

       3rd party backup     ?

Outputs

      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)

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  

      Team Foundation Server  

      Git 

      Mercurial 

      Perforce 

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

 

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

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