Snapshot Comparison enables users to determine the differences in their SQL Server environments over time. Having the ability to compare solution items at different points in time can save a lot of time for developers and DBA's who are attempting to track down the source of either consistency or performance problems.
Notice: Snapshot Comparison works hand-in-hand with the DOC xPress feature and requires more than one snapshot within your metabase to be useful, whether those snapshots are of the same or different solution items; if this has not yet been done, go to "Creating your DOC xPress Solution" and follow those steps.
• View changes that have occurred in your SQL environment over time
• Find differences between two separate environments
Compare Your Snapshots
Notice: Snapshot Comparison works hand-in-hand with the DOC xPress feature and requires more than one snapshot within your metabase to be useful, whether those snapshots are of the same or different solution items; if this has not yet been done, please follow the steps described in "Creating your DOC xPress Solution".
1. Open Snapshot Comparison from the Pragmatic Workbench.
2. Set the Left and Right Source by choosing the Solution, Solution Item, and version (snapshot date) to compare.
o If you attempt to compare objects that are of different technology types, you will receive a message that advises against this.
3. By default, the Left and Right Starting point will be set to the root of the source. This can be changed, however, to create a more specific comparison.
o Adjusting the left and/or right starting points are an excellent way to compare the same item that has been been moved from one environment to another. For example, in the above screenshot we are comparing the SSIS Package "AdventureWorksETL" that has been deployed from development to production environment.
4.Click "OK" once the above step is complete.
o This will load the snapshots into the comparison window for review.
To save space in your DOC xPress metabase, a new snapshot may not be created every time you run the snapshot. Only when an object or property changes between the last snapshot and current will a new version be created.
• You can choose to view objects that are equal, not equal, exist on the left side only, and exist on the right side only.
• Just like in BI Compare, you may filter in or out specific objects from the comparison.
• You may also choose to switch an individual side of the comparison from the window as well.
As an example, in the comparison on the right, there is a stored procedure that exists in the snapshot on the left that doesn't exist in the snapshot on the right. This makes all parent levels unequal so the user can locate the difference.