Running the Data Pump Utility From the Command Line

Contents

Depending on the operating system, use the appropriate file to run the data pump utility.

• For Windows, run migrate.bat
• For Linux/Unix, run migrate.sh

  Note: Do not use migrate.bat to convert the database type from EPPM to PPM or vice-versa.

To run the data pump utility from the command line, proceed as follows.

1. Open a new command line console.
2. Change directory to where the utility is located.
3. Enter appropriate parameters to define the migration.

   On a Windows Operating System

   • SQL Server to Oracle Data Migration Syntax

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

   • Oracle to SQL Server Data Migration Syntax

     Migrate.bat -source admuser/admuser@oracle:rcgsrv:1521:rcg02 -target sa/sa08@sqlserver:rcgsrv:1433:vader_pmdb -db PM

   • SQL Server to Oracle Data Migration Syntax 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 admjeff -privuser privjeff -pubuser pubjeff

   On a Unix/Linux Operating System

   • SQL Server to Oracle Data Migration Syntax

     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> -admpass <admuser password at target> -privuser <privuser at target> -privpass <privuser password at target> -pubuser <pubuser at target> -pubpass <pubuser password at target> -pxrptuser <pxrptuser at target> -pxrptpass <pxrptuser password at target> -bgjobuser <bgjobuser at target> -bgjobpass <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

   • Oracle to SQL Server Data Migration Syntax

     sh migrate.sh -source privuser/privuser@oracle:oldb-orcl:1521:PMDB -privuser <privuser at target> -privpass <privuser password at target> -pubuser <pubuser at target> -pubpass <pubuser password at target> -pxrptuser <pxrptuser at target> -pxrptpass <pxrptuser password at target> -target sa/sa@sqlserver:jdoe-lap\primavera:1433:PMDB

     For example,

     sh migrate.sh -source privuser/privuser@oracle:oldb-orcl:1521:TEST -privuser privuser -privpass privuser -pubuser pubuser -pubpass pubuser -pxrptuser pxrptuser -pxrptpass pxrptuser -target sa/Primavera1@sqlserver:jdoe-lap\primavera:1433:test