Note: Do not use the migrate database wizard to convert the database type from EPPM to PPM or from PPM to EPPM.
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 PMWith 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:PMDBFor 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