31 October 2017
31 October 2017

Introducing the updated HTML comparison report in SQL Compare 13.1

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.

In SQL Compare 13.1, we’ve updated the interactive HTML comparison report type, providing simpler cleaner reports that focus on the differences between the compared databases.

This gives you the option to inspect those difference in 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.

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

You may also like

  • Article

    How to use custom filters in SQL Compare

    I used to work at JD Edwards, and in one of our ERP products we had a cumbersome database schema. There were tables like this: These were the tables that held various information in the system. Trying to find data was an exercise in frustration, even for those of us that were familiar with it.

  • Article

    Using SQL Data Compare to Synchronize Custom Error Messages

    One way to offer a better experience to our application users is to anticipate likely mistakes they could make, such as when filling in a web form, and provide them with a meaningful error message that allows them to continue quickly with their work. One way to do this in SQL Server to is to

  • Article

    Automating database deployments to and from source control using SQL Compare and PowerShell

    Our goal is to show how to use SQL Compare Pro command line with PowerShell to automate the following processes: Getting a new database into version control, or updating the object scripts in the VCS to reflect the latest database changes Creating a new build script for a database version, from the object scripts in

  • Article

    Using SQL Compare with Dynamic Data Masking

    One of the features that I hear many DBAs excited about in SQL Server 2016 is Dynamic Data Masking (DDM). This allows DBAs to centrally set a mask that is returned for a table column instead of the actual data. This means an application that wants to limit what information is returned to certain users

  • University

    Take the SQL Comparison Tools course

    This course takes you from installation all the way up to getting the most out of the industry standard tools for SQL Schema & Data comparison. Whether you need to deploy changes or explore the differences between your environments, through this course you'll learn how SQL Compare and SQL Data Compare can help you do the job quickly, simply, and with zero errors.

  • Forums

    SQL Compare Forum

    Forum for users of SQL Compare schema synchronization utility