DBA xPress Schema Inspector Snapshot Tool

Icon Description
DBA xPress Schema Inspector Snapshot Tool IconThe Schema Inspector Snapshot Tool creates point-in-time copies of database objects and saves them as an  XML file. Compare snapshots to other snapshots or live database comparisons and synchronize schema elements of SQL Server databases using the Schema Inspector.

Using the Schema Inspector Snapshot Tool

1. Select the Schema Inspector Snapshot Tool in the SentryOne Workbench to open the Choose Source For Snapshot window.DBA xPress select Schema Inspector Snapshot Tool

2. Enter a SQL Server connection or select a previous connection from the drop down list. Enter your connection credentials, then select a database for the comparison.

DBA xPress Choose Source For Snapshot window select SQL Server
DBA xPress Choose Source For Snapshot enter credentials and database

Note:  Schema Inspector Snapshot Tool automatically starts a search for local servers when it starts. Select Find Local Servers if you know a new server has appeared since the application started, or the dialog opens before the initial search completes. 

Note:  Selecting SQL Server Security gives you the option to enter a username and password.

3. Select Ok to begin loading the data base for the snapshot. 

DBA xPress Choose Source For Snapshot select Ok
DBA xPress Loading database for snapshot prompt

Note:  Once the selected database has loaded, the Save Snapshot window displays.

4. Enter a meaningful name for the snapshot, then select OK to save your snapshot.DBA xPress Save Snapshot window

Success: You have saved your snapshot!DBA xPress Snapshot Saved prompt