Product articles
SQL Toolbelt
Schema Comparison Options
Introducing the updated HTML comparison…

31 October 2017
31 October 2017

Introducing the updated HTML comparison report in SQL Compare 13.1

SQL Compare 13.1 brings improvements to the interactive HTML comparison report type, providing simpler cleaner reports that focus on the differences between the compared databases.

Whether you need to deploy changes, or simply view the differences between two SQL Server databases, SQL Compare helps you do the job quickly and accurately by exploring what’s changed in each database object, down to individual lines of SQL. The new interactive HTML comparison report type, in SQL Compare 13.1 and later gives you the option to inspect the differences between the compared databases in more detail, so that you can fully understand what the changes are and share the information in an easily accessible and readable format.

You can access the new report from the Tools menu:

From the options dialog, choose the Interactive HTML report type. You can optionally choose to include all objects with differences, or just those objects you’ve selected for deployment. By default, the report won’t include any of the objects that haven’t changed, but you can include those too, if you like.

When ready, choose Generate to create the report:

The report will be saved inside your Documents folder, and automatically opened in your web browser:

The report header shows a summary of the differences in the compared databases. In this example, you can see that two objects have been modified, with no objects being added or removed.

The main report body shows the name and type of each of the changed objects, and each object can be individually expanded to show the detail of each difference:

This new report is visually simpler and cleaner, which helps the reader to focus on the differences when compared to the previous version of the interactive report.

This change also improves consistency across other Redgate products, such as ReadyRoll, DLM Automation and DLM Dashboard, which already use the new report style.

The modern look and feel of the reports makes reviewing differences faster and easier, and introduces a common theme and approach across the products in your Redgate portfolio.

We’re looking for your feedback

We’d love to hear about your experience of using the new HTML report in SQL Compare. If you have any feedback or suggestions for this new feature, or any other aspect of using SQL Compare, let us know on UserVoice.

And if you’d like to find out more about what we’re working on now and what’s coming up next, check out our roadmap.

You may also like

  • Article

    Deploying Data and Schema Together with SQL Compare or SQL Change Automation

    You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure.

  • Article

    The Changing Role of SQL Server Monitoring

    Grant Fritchey explains how a modern monitoring tool must adapt, as our SQL Server databases grow in number and size, and migrate onto new cloud-based, containerized or virtual machine-based SQL Servers.

  • Article

    Monitoring SQL Server Security: What's Required?

    If we know how a database is likely to be attacked, we can arrange our lines of defense, and install the monitors required to detect any attempts. However, some types of attack are difficult to imagine, so we also need our monitoring tool to be adaptable, so that it can collect a more diffuse collection of metrics, and then help us determine the reason for any sudden change in the patterns of access .

  • Webinar

    Extending DevOps to the database: continuous integration

    Are you ready to take the next steps in your Database DevOps journey to see how to automate database deployment alongside your application code?

  • Forums

    SQL Compare Forum

    Compares and synchronizes SQL Server database schemas