Once the database files on the source machine are prepared, you can add the database to the destination machine.
To do this you must:
• Restore the RDBMS data from the source database onto the destination machine.
• Extract the BDB database from the dump file created in the BDB Administration Tools.
• Reset the password for the database to match the password assigned to a user on the destination machine.
• Register the database with the Node Manager on the destination machine.
Restore the database
The first step in the process is to restore the RDBMS data from the database onto the destination machine. To complete this step, please refer to the following resources for information on restoring a database in the RDBMS:
• pgAdmin documentation on the Windows Start menu
• http://www.oracle.com/pls/db112/homepage
Further details on administration tasks in the RDBMS are also available upon request from CARIS Customer Service. |
The next step in the process is to extract the dump file that was copied from the source machine.
Extract the Database Dump
To extract a dump file:
1. Select the Extract Database Dump command.
Menu | File > Extract Database Dump |
The Extract Database Dump File dialog box is displayed.
2. Select the file you want to extract and click Open.
3. Select a location into which to extract the file and click OK.
The file is extracted into the selected location. For a more detailed explanation of the Extract Database Dump command, see Extract Database Dump.
The next step in the process is to update the superuser password for the database using the Database Configuration Utility.
Configure the Database Password
The Database Configuration Utility is a command line tool that allows you to configure settings for a database. To change the password for a database using this tool:
1. Open a command prompt window.
2. Switch to the Bin directory for BDB Server on your machine.
3. Enter the following command line:
bathysvrconfigutil.exe /db=database location\database name
/su=username/NewPassword@localhost:5432
• Replace "database location" and "database name" with the correct values.
• Replace "username" with the superuser account for your RDBMS. For PostgreSQL, the default is "postgres". For Oracle, the default is "system".
• Replace "NewPassword" with the password of a superuser on your machine.
• Replace "localhost:5432" with the appropriate PostgreSQL port number or Oracle service name.
4. Press <Enter>.
The password for the database is updated. See Database Configuration Utility for a more detailed description of this tool.
The final procedure for moving a database is to register the database in the Node Manager.
Register the database
In order to register a database, the source files need to be in a defined node location. If the dump file was extracted to a node location defined in the file system table, the database can be registered in the Node Manager. If not, before you can register the database you will need to either:
• copy the extracted files into a defined node location, or
• create a new node for the current location, see Edit Node Locations.
To register the database:
1. Start the BDB Administration Tools.
2. Login to a Node Manager.
3. Double-click the Database Properties icon in the Tools panel.
The Node Manager and its registered databases are listed.
4. Select the Node Manager and choose the Register database command.
Menu | Database > Register |
Pop-up | Node Manager > Register database |
5. In the Register Database dialog box, select the moved database and click OK.
The moved database is added to the list of Available Databases in the Database Properties page and is now ready to be used on the destination machine. See Register a Database for a more detailed description of this process.