Viewing a Database

Viewing a database allows you to view in the Autoaction Database Manager the contents of any current or backup database.

To view a database

  1. Click Database Maintenance on the Tools menu (or press Ctrl+F4).

    The Security Server Selection dialog box is displayed.

  2. To maintain the databases, you must be a member of the SPO Users group on one of the servers in the list. Highlight the server on which you want Autoaction Database Manager to verify your privileges and click OK.

    If you are a member of the SPO Users group on that server, the Database Maintenance dialog box appears.

  3. In the System Name drop-down selection list, either select an Operations Sentinel server or enter a new name.

    The Backup and Current boxes list the databases that are currently installed and those that are in the backup directory.

  4. Select the database you want to view from either the Backup or Current list. Click View.

    Autoaction Database Manager dumps the database to a document in the document view and displays status messages in the results pane. It also adds an entry to the SP-DISTRIBUTE-AMS log file.

  5. If you want to keep the source statements in the document pane, save the contents of the pane to a file.

Note: While the Database Maintenance dialog box is open, the commands to build, verify, distribute, and dump a database are unavailable.