To migrate your P6 Professional schema to P6 EPPM:
- Open the Migrate Database wizard by completing the following:
- Navigate to the \database folder of your P6 Professional installation.
- Run migrate.bat (for Windows) or migrate.sh (for 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:
- If you want to use existing tablespaces, select Use existing tablespaces and then select the tablespace names from the lists.
- If you want to create new tablespaces, 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.
- 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 data into the P6 Professional database.