Migration

OwlDB provides a migration feature to use the usersr existing database with OwlDB. There is an Analyzer to evaluate compatibility before migrating, and a Migrator to perform the migration. The users can only run Analyzer and Migrator when the database operational status is Running and the instance status is Normal.

Note

The Compatibility Analyzer and Migrator features currently only support Oracle, see the 'Support Coverage and Specifications' page.

Analyzer

1. Navigate to the OwlDB console screen > Administration > Migration > Analyzer menu.

2. Click the DB Alias drop-down button to pull down the database the users want to evaluate for compatibility.

3. Click the Analyze button.

4. Key in the information of the source database (hereafter referred to as the source database) for which the users want to evaluate compatibility.

Item	Description
Title*	Title of the database compatibility evaluation
Type*	Engine type of the source database
ID*	User ID of the source database
Password*	User PW of the source database
Address*	IP address name of the source database
Port*	Port number of the source database
SID*	SID of the source database

_*indicates a required field.

1. Click the Analyze button.

2. The users can check the progress information on the OwlDB Console screen > Administration > Migration > Analyzer > Status.

Figure 1. Analyzer progress information

---

Analyzer results

The users can check Analyzer results by going to OwlDB Console > Administration > Migration > Analyzer > Analyzer > Analyzer Title.

Figure 2. Analyzer detail

Migrator

1. Navigate to the OwlDB Console screen > Administration > Migration > Migrator menu.

2. Click the DB Alias drop-down button to pull down the database to perform the migration.

3. Click the Migrate button.

4. Key in the information for the source database to perform the migration.

Data Connection

Connects to the source database to be migrated.

Item	Description
Title*	Database migration title
Type*	Engine type of the source database
ID*	User ID of the source database
Password*	User PW from the source database
Host*	IP address name of the source database
Port*	Port number of the source database
SID*	SID of the source database
Target Database*	Alias of the target database

_*indicates a required field.

Type Conversion

Views information about converting the data type of the source database.

Note

Data types that have been converted are highlighted with orange highlighting.

Summary

Provides a summary of the information keyed in in the previous step.

1. Click the Migrate button.

2. The users can see the progress information on the OwlDB console screen > Administration > Migration > Migrator > Status.

Figure 3. Migrator progress information

Migrator results

The users can check the migrator results by going to OwlDB Console > Administration > Migration > Migrator > Migrator > Migrator Title.

Figure 4. Migrator detail