Migrating P6 EPPM Schema to P6 Professional for Oracle Database

To migrate your P6 EPPM schema to P6 Professional:

1. Open the Migrate Database wizard by completing the following:
   1. Navigate to the database folder of your P6 EPPM installation. For example, C:\P6EPPM_1\database\ (for Windows) or /u01/P6EPPM_1/database/ (for Linux).
   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 an existing tablespace, 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.