Client Tools Guide › File Menu › Open From File › Open from Database

Open from Database

This option enables modification of database files directly on the production server without the need to create intermediary files or to import database files, which would otherwise involve the stages of import, processing, and export back to the production computer. This option is useful for implementing simple changes on the production server.

It can be used only after files had been imported and exported back to the production server. It is only after export of files to the production server that required files are created on the target server.

By working on the production server, the Role Engineer has essentially waived the inherent protection of the sandbox principle. Extreme care should be taken when working directly on a production server. Only minor changes should be performed using this option.

Note: Before attempting to run the CA GovernanceMinder Database Wizard, verify that your connection to the remote computer is working.

To open from a database

1. Select Open from Database on the menu bar.

   The Database Wizard appears.

2. Fill in the following information in the Database Wizard window.

   Type

   Specifies the type of database data that you are downloading.

   Server

   Defines the remote server's IP address.

   Database

   Defines the database file name on the remote computer

   Windows Authentication

   Select this option to access the MS SQL server using the current user's Username and Password that is associated with Windows operating system.

   User Name, Password

   Defines credentials to access the database host

3. Click Next to continue to the next screen in the wizard.
4. Choose the file type from the list and file name from the list of files. If you have saved a configuration on the production server, you can work directly in that configuration.
5. Click Next to finish the procedure and begin working.

More information:

File Formats in CA GovernanceMinder