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.
- Navigate to the database folder of your P6 EPPM installation. For example,
- 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:
- 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.
- 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.