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