Using dbmigrate to move an existing myMO HSQL database to Oracle

Document ID:7005309

Creation Date:05-Feb-2010

Modified Date:26-Jun-2012

Micro Focus Products:

Operations Center

Environment

myMO 4.5

myMO 4.6

myMO 4.7

Situation

NOTE*

If you intend to use Oracle as a database for myMO, it is
strongly recommended that you create a separate schema to host
myMO tables. This will make it easier to migrate and/or
upgrade myMO database in the future.

Resolution

If planning to use dbmigrate to move an existing myMO
HSQL database to Oracle, you must specify a value for the
'jdbc.default.schema' property in portal-ext.properties
file.

This property is only necessary if you run dbmigrate against
Oracle. It is not necessary if you are migrating for SQL
Server. The value for the schema cannot be SYS or other
predefined oracle system schema's.

It must be a new schema created to host myMO database
tables.

For example, if you created a schema called 'myMO' to host the
myMO tables, the corresponding line in the portla-ext.properties
file will look as follows, 'jdbc.default.schema=myMO'