When it comes to identifying and analyzing SQL schema differences, choosing an easy-to-use and multifunctional tool can be very important. Among the tools the Devart team offers, there is a powerful and reliable database schema comparison tool - Schema Compare for SQL Server. It enables you not only to significantly reduce time on SQL Server database comparison and synchronization but also view and analyze what changes were applied to the files.
Later, the result of the database comparison can be exported to one of the following file formats: HTML, XLS, XML. In the article, we are going to explore an interactive HTML comparison report type that contains the comparison analysis with a set of user interactive options. The dbForge Schema Compare tool generates a database comparison report as a read-only HTML file in which you can include filtered objects or objects selected for synchronization, or only objects with differences. In addition, it displays the deployment script, warnings, modified changes, comparison and synchronization options.
The HTML comparison report type enables you to:
To get started, download and install dbForge Schema Compare for SQL Server, and then compare two SQL Server databases by following the steps in the Comparing schemas documentation topics.
After data sources are compared, you will see the comparison results in the Results window that can be further synchronized and exported to HTML, XLS, or XML data reports.
To generate an HTML comparison report, do the following:
1. On the Comparison menu, click Generate Comparison Report.
2. In the Comparison Report dialog, select the HTML file format, specify a file location, and set report options to customize it:
2. To generate a report, click Generate.
Let's have a closer look at each section the report has.
The report header displays information that includes:
The Changes section displays objects grouped into categories. You can see the number of objects next to each category:
In addition, you can expand the DDL script for each object to be compared by clicking the object in the interactive HTML report.
The Warnings section displays warnings or informational messages that require the user's attention.
The Script section displays a synchronization script that you can execute to synchronize schemas.
The Options section is divided into two groups: Comparison displaying comparison options and Synchronization displaying synchronization options.
Upon the report generation, the report with the Removed-added lines option will have the following view in the Modify section. The new text will be highlighted with the green color while the old one - with the pink color.
When the Crossed out lines option is selected, the report will have a different view in the Modify section. The old text will be struck out and highlighted with a pink color.
The HTML comparison report is a readable interactive report using which you can easily navigate through the compared objects, view a deployment script, analyze differences between two schemas, and share the report as an attachable file. Along with the generation of the HTML report feature, dbForge Schema Compare for SQL Server offers a lot of useful and powerful features that help improve schema comparison and synchronization significantly.
We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.
