Migrate Database Information from Previous Releases to the Arcserve Backup Database

Installing and Configuring Arcserve Backup UNIX and Linux Data Mover › Migrate Database Information from Previous Releases to the Arcserve Backup Database

Migrate Database Information from Previous Releases to the Arcserve Backup Database

Arcserve Backup lets you migrate the database information from BrightStor ARCserve Backup r11.5 to this release. Migrating the data lets you perform restore operations using data that was created with BrightStor ARCserve Backup r11.5.

Arcserve Backup provides you with the following tools to execute the data migration:

IngresDBDump.sh--Lets you extract data from the Ingres database on the BrightStor ARCserve Backup r11.5 server.
MergeIngres2Sql.exe--Let you merge the extracted data into the Arcserve Backup database.
Note: This utility lets you migrate the Ingres database information to Arcserve Backup databases running Microsoft SQL Server and Microsoft SQL Server Express Edition.

To migrate database information from a previous release to the Arcserve Backup database

Install Arcserve Backup on the primary server.
Important! You should not uninstall BrightStor ARCserve Backup r11.5 from the target data mover server until after you complete this task.
Log in to the BrightStor ARCserve Backup r11.5 server.
Copy IngresDBDump.sh from the Arcserve Backup installation media to the BrightStor ARCserve Backup r11.5 server.
Note: You must copy IngresDBDump.sh from the directory on the Arcserve Backup installation media that corresponds with the operating system that is running on the target data mover server.
- Linux platforms:
```
DataMoverandAgent\Linux
```
- HP platforms:
```
DataMoverandAgent\UNIX\hp
```
- Solaris platforms:
```
DataMoverandAgent\UNIX\solaris
```
- AIX platforms:
```
DataMoverandAgent\UNIX\aix
```
From the BrightStor ARCserve Backup r11.5 server, execute IngresDBDump.sh.
IngresDBDump.sh dumps the session, tape, and pool data from the Ingres database to common.dmp, aspool.dmp, and astpses_tmp.dmp. These files will be located in the following directory:
```
$BAB_HOME/dbase/ingres/tmp
```
The dump files will contain the following data:
- common.dmp--The host name and the operating system name on the UNIX or Linux computer.
- astpses_tmp.dmp--The session information and the associated tape information that was dumped from the Ingres database.
- aspool.dmp--The pool data that was dumped from the Ingres database.
Copy common.dmp, aspool.dmp, and astpses_tmp.dmp to the primary server.
From the primary server, execute MergeIngres2Sql.exe using the following syntax:
```
MergeIngres2Sql.exe <-dir> <-migrate4recognizedmedias> [-help]
```
Note: <> indicates required arguments.

Arguments:
```
<-dir>
```
Lets you specify the directory location of the copied files (common.dmp, astpses_tmp.dmp, and aspool.dmp).
```
<-migrate4recognizedmedias>
```
Lets Arcserve Backup migrate the information for all tapes created using BrightStor ARCserve Backup.
```
[-help]
```
(Optional) Lets you view help for this tool.

MergeIngres2Sql.exe migrates the Ingres database information from the BrightStor ARCserve Backup server to the database on the Arcserve Backup server.