Migrating P6 EPPM Schema to P6 Professional with Oracle
To migrate your P6 EPPM schema to P6 Professional:
- Open the Migrate Database wizard by completing the following:
- Navigate to the database folder of your P6 EPPM installation. For example,
C:\P6EPPM_1\database\
(with Windows) or /u01/P6EPPM_1/database/
(with UNIX or Linux).
- Run migrate.bat (with Windows) or migrate.sh (with UNIX or Linux).
Note: After each step, click Next.
- On the Select Migration Type screen, select Schema Migration.
- On the Select Source screen, select Oracle.
- On the Connection Information screen, enter the connection details for the source database and private database user.
- On the Select Target screen, select Oracle.
- On the Connection Information screen, enter the connection details for the target database and system database user.
- On the Configure Oracle Tablespaces screen, complete one of the following steps:
- On the Specify Oracle Tablespace Location screen, enter the location at which you want to create each tablespace and then click Create.
- On the Create Oracle Users screen, in the User Name, Password, and Confirm Password fields, enter the credentials for each database user.
- 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.
Migrating Database Schema
Prerequisites for Schema Migration
Migrating P6 EPPM Schema to P6 Professional with Microsoft SQL Server