Using dbmigrate to move an existing myMO HSQL database to Oracle

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.

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'