ApexSQL Diff is a SQL Server and Azure SQL database comparison and synchronization tool which detects differences between database objects and resolves them without errors. It compares and synchronizes live databases, native or natively compressed database backups, database snapshots, scripts in source control and script folders and generates comprehensive reports on the detected differences • Compare SQL schemas from databases, backups, scripts and source control • Quickly identify line level differences between compared SQL databases • Automate and schedule database synchronizations • Deploy a database directly from source control • Integrate with all popular source control systems: Git, Mercurial, Perforce, Subversion, and Azure DevOps Server (TFS) • Report results to HTML, XML and Excel • Create executable installation packages • Compare SQL database schemas directly from SQL Server Management Studio or Visual Studio • Recognize all object interdependencies, even those that even SQL Server itself fails to identify, to ensure perfect sync scripts every time • Review the impact of the synchronization script before it is executed, including warning levels and messages • Augment the deployment script with your own pre or post synchronization scripts • Narrow schema comparison and synchronization to affected objects only • Restore selected objects from a database backup without restoring • Perform a remote update via an executable installation package
See also • ApexSQL Diff product page • FAQs • (Video) An introduction to ApexSQL Diff ApexSQL has more SQL add-ins for Visual Studio to improve SQL developer productivity |
