Migrating P6 Professional Schema to P6 EPPM for Oracle Database

To migrate your P6 Professional schema to P6 EPPM:

1. Open the Migrate Database wizard by completing the following:
   1. Navigate to the \database folder of your P6 Professional installation.
   2. Run migrate.bat (for Windows) or migrate.sh (for Linux).

      Note: After each step, click Next.

2. On the Select Migration Type screen, select Schema Migration.
3. On the Select Source screen, select Oracle.
4. On the Connection Information screen, enter the connection details for the source database and private database user.
5. On the Select Target screen, select Oracle.
6. On the Connection Information screen, enter the connection details for the target database and system database user.
7. On the Configure Oracle Tablespaces screen, complete one of the following steps:
   • If you want to use the existing P6 EPPM tablespaces for P6 Professional, select Use existing tablespaces and then select the tablespace names from the lists.
   • If you want to create new tablespaces for P6 Professional, enter the tablespace names and sizes in the tablespace name and tablespaces size (M) fields.

     Note: If you chose to use existing tablespaces, skip the next step.

8. On the Specify Oracle Tablespace Location screen, enter the location at which you want to create each tablespace and then click Create.
9. On the Create Oracle Users screen, in the User Name, Password, and Confirm Password fields, enter the credentials for each database user.
10. On the Migrate Options screen, enter the size of the batch that will be used for the SQL insert of P6 data into the P6 Professional database.