ApexSQL Diff is an SQL development tool that can compare SQL Server database tables, views, and all other SQL Server objects..
Features:
- Automate database comparisons, synchronizations and migrations
- Compare live databases, snapshots, scripts, Source control projects, and native backups
- Synchronize unattended with the Command Line Interface
- SQL Server 2014, 2012, 2008 R2, 2008, and 2005 support
- Proprietary parsing engine ensures Error Free Scripts every time!
- Native support for Git, Subversion, TFS, Mercurial and Perforce
v2014.0 [Jun 30, 2014]
Enhancements:
- The "Ignore data compression" option is added.
- The "Ignore WITH ENCRYPTION" option is added.
- Performance has been improved for database backup comparison up to 450%.
Fixes:
- The "The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)" error is encountered when running CLI after updating application through the "Get updates" option.
- The "Save" button from the "New project" dialog is not working after it's clicked once.
- The application reports two different DDL triggers, but there no differences between them in the "Script difference view" pane.
- The "Value cannot be null" error is encountered when the application is started in Windows XP.
- The project will not be saved after the "Save changes to project?" message is shown, after closing the "New project" window.
- Missing the warning message that SQL Server Management Studio should be closed during the application update.
- The inconsistent version number between the "About" window from the application, installer properties, and Control panel information.
- The incorrect information message is shown in the CLI while generating script.
- The Print and Print preview ribbon buttons are not in the appropriate tab.
- The "Disable DDL triggers" option is not working correctly.
- The "Exception of type 'System.OutOfMemoryException' was thrown" error is encountered when comparing databases with 100.000 objects.
- The incorrect release notes are shown when prompted with the "ApexSQL automatic update service" window.
Known issues:
- Local server result panel says that "No servers detected" although local instance exists when the application is used on 64bit operating system with 64bit SQL Server.
- Databases cannot be scripted to a Git source control repository.
Feature-rich relational database known for its high performance and excellent concurrency
