CARIS Bathy DataBASE Server : CARIS Bathy DataBASE Server : Database Procedures : Moving a Database : Database Source
 

Database Source

On the source machine, you need to prepare the database to be moved.

This involves:

Creating a dump of the database contents in the Node Manager.

Backing up the database in the RDBMS.

Copying the dump and backup files to the destination machine.

Database Dump

To dump a database:

1. Connect to the Node Manager in BDB Administration Tools.

2. Double-click the Database Properties icon in the Tools panel.

3. Select the database that you want to move.

4. Select the Dump Database command.

 

Menu

Database > Dump

Pop-up

Available Databases > selected database > Dump

The contents of the selected database are added to a .bdbzip file in the backup location of the database. The file will be named according to the database name and the date:

<databasename>EXPORT<YYYYMMDD_HHMM>.bdbzip

See Dumping a Database for a more detailed explanation of the Dump command.

RDBMS Backup

Next you need to backup the database in your RDBMS.

Please refer to the following resources for information on backing up 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.

When this is complete, you are ready to move the dump and backup files to the destination machine.

Move the source files

To move the necessary files:

1. Select the database dump file in the database backup location defined in the Bathy Node Location Editor.

2. Copy the file to a shared directory or external disc.

3. Select the backup file for the RDBMS database in the directory specified during the backup.

4. Copy the file to the same shared directory or external disc that was used for the dump file.

5. Copy and paste the files from the shared directory/external disc to the appropriate backup directories on the destination machine.

The files are now ready to be activated on the destination machine. Go to Database Destination for the destination machine procedures.