dbForge Schema Compare for SQL Server is a fast and trustworthy database schema comparison software, facilitating easy comparison and synchronization of SQL Server databases without compromising accuracy.
The internal feature of this tool allows you to automate schema synchronization. Besides, the SQL diff tool is compatible with SQL Server Management Studio. This software is versatile enough to work with SQL Server, SQL Azure, and SQL Server on Amazon RDS.
The key features of dbForge Schema Compare are many. For instance, you can compare live databases or SQL scripts with SQL Server native backups or script folders. You can also sync staging or production databases with development databases. This software generates precise T-SQL scripts for database deployment that are both concise and accurate. Additionally, restoring functions and procedures from SQL Server native backups is possible.
There is also the option of automating routine synchronization tasks with command-line interface. Users can export schema comparison results to HTML, Excel, and XML formats. Lastly, dbForge Schema Compare sets up database development with Continuous Integration, which ensures that you always work with the latest version of the product from the official Devart website.
Overall, we highly recommend dbForge Schema Compare for anyone who needs to compare and synchronize their SQL Server databases efficiently.
Version 5.2.8:
* Improved the behavior of data sorting in Data Editor
* Added the ability to resize the search text field
* Added a warning when trying to save read-only files with the applied changes
* Improved the display of the database server name on the Start Page
Version 5.1.71:
* Redesigned Progress Window for schema comparison and synchronization
* In-place SQL Formatting option for the text compare control
* Pre/Post-scripts execution tab in Schema Synchronization Wizard
* Append Timestamp to the File Name option in Schema Synchronization Wizard
Version 5.0.57:
* Object filter
* Redesigned objects text diff control
* Redesigned schema comparison report window
* Redesigned schema comparison report in HTML
* Redesigned schema comparison ssms add-in window
Version 5.0:
* Object filter
* Redesigned objects text diff control
* Redesigned schema comparison report window
* Redesigned schema comparison report in HTML
* Redesigned schema comparison ssms add-in window
Version 4.5:
Connectivity support for SQL Server 2019
Product now integrates into SSMS v18
Lots of Azure improvements implemented
Version 4.4:
*SQL Server 2016 Service Pack 1 (SP1) new syntax support
*SQL Server 2017 new syntax support
*The latest SQL Server Management Studio v17.2 integration support
*Azure SQL Data Warehouse support
Version 4.3:
*Comparision and synchronization of system-visioned tables
*New comparision and synchronization options
*PowerShell supported
*Trial product activation implemented
*Extended comparison reports functionality
*Command-line interface for the scripts folder comparison
Version 4.2:
*SQL Server 2016 support
*Product now integrates into SSMS 2016
*Many new comparision and synchronization options added
*Enchanced backup support
*Sequences support greatly improved
*Improved security during synchronization process
*Valid support of "WITH CHECK" and "WITH NOCHECK" constraints
Version 4.1:
- Redesigned Comparison Document UI
- SSMS Integration Support
- Database script folder creation and comparison
- Comparison with database script folder in version control
Version 4.0:
*Custom mapping for tables
*Zooming font size in Text Comparer