Managing Snapshots

• Accessing Snapshots
• Deleting a Snapshot
• Saving Snapshots locally
• Searching for a Snapshot
• New Snapshot
  

Clicking the  Manage Snapshots at the top of every page, just below the main tab. A dialog as shown below will be seen:

Accessing Snapshots:

All the snapshots created by the current user will be grouped based on the corresponding SQL Server host name and listed under Database Servers on the left. Clicking on each of the host name will list the snapshots that were taken from the corresponding SQL Server, on the right in a tree structure. The parent node would be the database name in SQL Server for which the snapshot was taken. You could expand/collapse the tree nodes by clicking the   icons.

Under each parent node the list of all snapshots that were taken for that particular database would be listed sorted alphabetically. Each snapshot listed, will contain the name, time at which the snapshot was taken, delete and save icons.

Note: The latest set of snapshots that were created using DBChangeManager could also be accessed from the Home page under the dashboard view named My Recent Snapshots

Deleting a Snapshot

You could delete a snapshot by clicking the  Delete Snapshot corresponding to that snapshot

Saving Snapshots locally

You could save the snapshot into your local machine as a SQL script file by clicking on the Save corresponding to the snapshot. You could use the SQL Script file for versioning. You could load the same SQL script file for schema comparison from within DBChangeManager.

Searching for a Snapshot

You can search for a snapshot name through the Search box placed at the right top corner. The search does a "contains" match of the string provided. For any search string provided, DBChangeManager would list all the snapshots whose name contains the search string.

New Snapshot:

You could also create a new snapshot from within the Manage Snapshots dialog by clicking the 'New Snapshot' link provided at the top. (Refer Creating New Snapshot)