Running the Migrate Database Wizard From the Command Line

The Migrate Database Wizard allows you to migrate between relational database management systems, that is:

from SQL Server to Oracle
from Oracle to SQL Server
from one Oracle server to another
from one SQL server to another
Note: Migration to and from Oracle Autonomous Databases is not yet supported.

You cannot use the migrate database wizard to convert the database type from EPPM to PPM or from PPM to EPPM. To convert the database type between PM and EPPM databases, use the process described for migrating the database schema.

To run the migrate database wizard from the command line, complete the following steps:

Open a new command line console.
Go to \install\database.
Run the command with the following parameters to define the migration:
With Windows

migrate.bat -source sa/sa@sqlserver:rcgsrv:1433:vader_pmdb -target system/manager@oracle:rcgsrv:1521:rcg02 -db PM

With Windows (Creating Non-Default Oracle Users)

migrate.bat -source sa/sa@sqlserver:rcgsrv:1433:vader_pmdb -target system/manager@oracle:rcgsrv:1521:rcg02 -db PM -<admuser> <admuser password> -<privuser> <privuser password> -<pubuser> <pubuser password>

With UNIX or Linux

sh migrate.sh -source sa/sa@sqlserver:saumverm-lap\primavera:1433:PMDB -dattbsp <Name of data tblspc at target> -ndxtbsp <Name of index tblspc at target> -pxtbsp <Name of px tblspc at target> -lobtbsp <Name of LOB tblspc at target> -<admuser> <admuser at target> -<admuser password> <admuser password at target> -<privuser> <privuser at target> -<privuser password> <privuser password at target> -pubuser <pubuser at target> -<pubuser password> <pubuser password at target> -<pxrptuser> <pxrptuser at target> -<pxrptuser password> <pxrptuser password at target> -<bgjobuser> <bgjobuser at target> -<bgjobuser password> <bgjobuser password at target> -target system/admin@oracle:oldb-orcl:1521:PMDB

For example:

sh migrate.sh -source sa/sa@sqlserver:saumverm-lap\primavera:1433:PMDB -dattbsp PMDB_DAT1 -ndxtbsp PMDB_NDX1 -pxtbsp PMDB_PX_DAT1 -lobtbsp PMDB_LOB1 -admuser admuser -admpass admuser -privuser privuser -privpass privuser -pubuser pubuser -pubpass pubuser -pxrptuser pxrptuser -pxrptpass pxrptuser -bgjobuser bgjobuser -bgjobpass bgjobuser -target system/admin@oracle:oldb-orcl:1521:PMDB

Related Topics