Comparing Snapshots - Using the Filter Options
|Top Previous Next|
Snapshot Compare allows the use of filters to make it easier for the user to find the exact differences they are searching for.
There are two subsets of filtering
options. Both can be used before and after a snapshot is compared.
First, you have the option of filtering items by status.
Checking and unchecking the above
status checkboxes will cause the snapshot results to either show or hide items
in the respective status. For instance, the snapshot image below shows that
uspUpdateEmployeePersonalInfo has been modified in "aw snapshot
After the "Modified" checkbox is
unchecked uspUpdateEmployeePersonalInfo no longer appears
in the results view.
Re-checking the "Modified" checkbox will make uspUpdateEmployeePersonalInfo reappear.
There are five statuses that can be used to filter items in the snapshot compare.
|Modified||The object has been modified in on of the snapshots. The icon in the middle of the object name explains which object changed. indicates the object changed in Snapshot 2. indicates the object changed in Snapshot 1|
|New||The object is new in Snapshot 2. Also indicated by the icon|
|Deleted||The object existed in Snapshot 1, but not Snapshot 2. Also indicated by the icon|
|Not Equal||The object changed from Snapshot 1 to Snapshot 2|
|Equal||The objects are the same|
Snapshot compare allows the use of object filters to filter out types of objects before and after a snapshot. To filter out an object simply uncheck the checkbox next to an object name. When an object is unchecked it will appear in bold red text to indicate the filter has been set.
unchecking an object with child objects will check/uncheck all of its child
nodes as well.
Server" was unchecked and all of the child items were unchecked.
Pre-Comparison Object Filtering
Using an object filter before a snapshot is performed prevents the snapshot from comparing the filtered objects. If there are object types you do not want to be compared then uncheck the objects before peforming a snapshot compare. This is useful if the snapshot contains objects that will take a large amount of time to be compared when the comparison of those objects is unecessary.
Post-Comparison Object Filtering
Using an object
filter after a snapshot is performed simply hides in the results view. For
instance in the screenshots below the stored procedures are visible in the first
screenshot but not visible after the stored procedure filter option is
Stored Procedures are visible
Stored Procedures are hidden