ApexSQL Diff

Description

A Database Comparison tool for Microsoft SQL Server, including support for Databases, Script folders and Source control projects/labels.
ApexSQL Diff is a database comparison and synchronisation tool that automates and simplifies database change migrations. It detects schema conflicts between two data sources and resolves them without dependency errors. ApexSQL Diff can compare online databases, database backups and SQL scripts in files or source control systems.

Key Features:

• Support for Multiple Data Source Types: Compare live SQL databases, backups, snapshots, scripts and databases under source control.
• Forensics: Pinpoint discrepancies, inadvertent and malicious changes, missing and damaged objects and immediately resolve them.
• Error-free Migrations: Ensure that changes are propagated without problems or errors using proprietary dependency analysis algorithms.
• Selective Comparison: Specify comparison criteria. Compare or ignore specific SQL object attributes.
• Automation: Schedule your migration unattended, using the command line interface. See ApexSQL Diff API for a fully programmable interface.
• Backup Recovery: Revert changes from a backup without the need to perform a full restore.
• Database Versioning: Deploy a specific SQL database version or label directly to or from source control.
• Risk Management: Easily reverse any changes made, automatically creating a backup prior to synchronising.
• Object Level Recovery: Restore and repair individual objects from another database or a recent backup.
• Change Propagation: Promote changes from development or test to production environments.
• Analysis and Reporting: Create end-user reports to document differences in your environments.
• SSMS Integration: Compare SQL objects directly from SQL Server Management Studio.
• Support for all SQL Server versions: Compare and synchronize all objects created in SQL Azure, SQL Server Express, SQL Server 2014, 2012, 2008, and 2005 databases.