Comparing Snapshots - Understanding the Results
|Top Previous Next|
Snapshot Compare makes it easy to see what objects have been modified, added or deleted between two snapshots
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.
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
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)
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
select column1, column2, column3, column4, column5, column6, column7, column8, column9, column10 from dbo.Table
will be formatted as
This make the differences easily recognizable on a granular level.
In property mode the
properties of an object are compared in side-by-side windows with the difference
|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|