Understanding Snapshot Results

Comparing Snapshots - Understanding the Results

Top  Previous  Next

 

lightbulb_on

Snapshot Compare makes it easy to see what objects have been modified, added or deleted between two snapshots

 

Results Grid

 

After a snapshot compare has been performed the first thing to look at is the results grid. Any colored items indicate a change has occurred somewhere in one of the snapshots.

In the screenshot below we see that AdventureWorks SQL Server, Tables and Stored Procedures have changes in them.

 

 

By clicking the + on child objects we can see the changes to the individual objects.

 

The following is a legend explaining the colors and icons of the results grid.

Icons and Color Highlighting

   Object was modified in snapshot 2. Items will be highlighted in Green.
   Object was modified in snapshot 1. Items will be highlighted in Green .
   Object existed in snapshot 1 but does not exist in snapshot 2. Items will be highlighted in Pink.
   Object existed in snapshot 2 but does not exist in snapshot 1. Items will be highlighted in Light Gray.
   Object are equal in both snapshots.
   Objects are not equal in both snapshots. Changes made in both snapshots. Items will be highlighted in Green.


Any top level grid items such as server names, object types, ssis packages, etc will only show  or  to indicate whether changes have been found in the snapshots. Top level items that have changes will be highlighted in Green.


Comparison Window

To see the changes in the objects, select the object in the results grid and the comparison window will show the changes. There are two modes in which differences are display. Text Mode and Property Mode.

Text Mode

In text mode the differences in the script are shown in color coded, side-by-side windows. Any differences in the text of the object will appear in the window. (See Color Coding legend below)

 

Copy Source

The option to copy the current script in the comparison window is available by clicking the  link at the top of the comparison window

Format script before compare

Checking this option will "prettify" a script before it is compared. This is particularly useful for script with very long lines of code that make it difficult to read the differences in the comparison window. For instance the following statement:

select column1, column2, column3, column4, column5, column6, column7, column8, column9, column10 from dbo.Table

will be formatted as

select

column1,

column2,

column3,

column4,

column5,

column6,

column7,

column8,

column9,

column10

from

dbo.Table

This make the differences easily recognizable on a granular level.


Property Mode

In property mode the properties of an object are compared in side-by-side windows with the difference highlighted



Color Coding

Green  The line of code or property value has changed
Light Grey  The line of code is present in the second script but not the first or vice versa
Pink  The line of code has been removed in the second script