ApexSQL Diff, a Server Data Compare Tool
ApexSQL Diff is a reliable SQL development tool which can be used to compare and coordinate various SQL Server database objects such as tables, views, and more. Apart from comparing different types of SSIS packages, ApexSQL Diff can compare and coordinate native backups, script folders, ApexSQL snapshots, and source control projects. The tool supports SQL Server on Amazon RDS and Azure SQL Database. ApexSQL Diff has native support for Mercurial, Git, Team Foundation Server, Perforce, and Apache Subversion so it can create a source control repository independently, and compare and synchronize different objects directly against the source control project.
With the object filter feature, difference filter feature, and difference by type feature, users can select types of objects for the comparison after they have set up data sources. With the 'Get by label' option, it is possible to compare a database with a specific label of a source control project and perform the synchronization process. Users can schedule the time to synchronize database schemas automatically unattended with the Command Line Interface. When the comparison is finished, users can export comparison results into XML, HTML, and Excel. ApexSQL Diff offers an opportunity to create executable installation packages that users can run without any need to install any other software.
ApexSQL Diff can be used to repair or reverse changes from backup files if a user made some unwanted changes.
The ApexSQL Diff has three versions – Community, Standard, and Professional which include different options:
- The Community edition is free of charge and offers support for SQL Azure databases, SQL Server Express databases. It allows basic comparison and synchronization.
- The Standard edition can support previous SQL Server editions and synchronization and comparison of ApexSQL snapshots.
- The Professional edition has all options from the paid Standard edition, including the support of CLI, the extension of the deployment script with pre-synchronization and post-synchronization scripts, ability to create a live database from scripts, possibility to deploy the latest changes of any chosen object directly from source control, as well as the ability to recover chosen objects from database backups.