Product articles SQL Compare Schema Comparison Options
How to examine differences with SQL…

18 September 2017
18 September 2017

How to examine differences with SQL Compare Summary View and SQL View

Jamie Wallis introduces the new Summary View, which is a tab that sits alongside SQL View and provides a more concise breakdown of the differences between two objects.

During the recent Redgate Hub Launch Livestream Steve Jones introduced the new Summary View, which is available now in SQL Compare.

The brand new Summary View is a tab that sits alongside SQL View and provides a more concise breakdown of the differences between two objects. We have achieved this by getting rid of the SQL and showing only the semantic differences between objects in a much more structured way.

Watch the video below to see how the new view works, alongside the updated SQL View:

Tools in this post

SQL Compare

Compare and synchronize SQL Server database schemas

Find out more

You may also like

  • Article

    Realistic, simulated data for testing, development and prototypes

    Generating realistic test data is a challenging task, made even more complex if you need to generate that data in different formats, for the different database technologies in use within your organization. Dave Poole proposes a solution that uses SQL Data Generator as a ‘data generation and translation’ tool.

  • Article

    Source controlling database users

    Where developers have their own databases, you need to ensure the user accounts are configured identically across all development and test server, or you'll inevitably hear the phrase “…but it works on my machine”. Alex Yates describes, strategically, how this might work.

  • Community event

    SQLSaturday Oslo

    SQLSaturday is a free 1-day training event for Microsoft Data Platform and SQL Server professionals, providing a variety of high-quality technical sessions. This is a great opportunity to network and learn from MVPs (Microsoft Most Valuable Professionals), local and international speakers. You can even win prizes from the sponsors – including Redgate – at the end of

  • Article

    SQL Change Automation Scripting: Getting Data into a Target Database

    Your strategy for loading a freshly built database with data will depend on how much you need. If just a few rows, then single-row INSERT statements will be fine, but for more than that you'll need to build insert the rows using native-format BCP. Fortunately, SQL Change Automation (SCA) can be used with either strategy, as Phil Factor demonstrates.

  • Forums

    SQL Compare Forum

    Compares and synchronizes SQL Server database schemas