Database Upgrade Considerations

You must upgrade your P6 EPPM database so it will work with the new version. Use the P6 EPPM Configuration Wizard to upgrade your database automatically. The wizard runs the necessary scripts to upgrade the database structure and an upgrade program to add data required by the new version.

Depending on your current version:

It might be necessary to upgrade your database to an intermediate version before upgrading to this version.
There might be other considerations for upgrading your database.

This section covers the things you should consider when upgrading from some earlier versions to version 24.

Release 19 or Earlier

If your current version is 19 or earlier, upgrade to version 19 prior to upgrading to version 24.

Release 8 or Later

Use the following list to upgrade from P6 EPPM Release 8 or later:

Back up your P6 EPPM database before beginning the upgrade process to ensure you will not lose any data due to unexpected problems.
Stop the P6 EPPM instance on your application server.
Uninstall the current instance of P6 EPPM.
Grant privileges to the system user by running manual_script_before_upgrade.sql.
Run the validate file for the current version of your P6 EPPM installation. Do not run the validate file for the release to which you are upgrading.
The validate file is located in the Database folder of the P6 EPPM physical media or download.
(Optional) Manually upgrade your database by running dbsetup.bat (for Windows) dbsetup.sh (for UNIX / Linux) which can be found in database folder of your P6 EPPM physical media or download.
Note: If you upgrade your P6 EPPM database using dbsetup, then you must connect to an existing database when using the P6 EPPM Configuration Wizard. Alternatively, you can use the P6 EPPM Configuration Wizard to upgrade your database.
Run the P6 EPPM Installation Wizard using setup.exe which can be found in your P6 EPPM physical media or download.
Connect to, or upgrade, an existing P6 EPPM database by using the P6 EPPM Configuration Wizard.
- To use the automatic upgrade, select Upgrade an existing P6 EPPM database.
- To upgrade your database manually using dbsetup, select Connect to an existing P6 EPPM database.
If necessary, update existing configurations.
Restart the P6 EPPM instance on your application server.
Clear your browser cache.
Test the new database to ensure that the upgrade has succeeded.

Release 6.2.1 or Later

All risk data fields are migrated when upgrading; existing fields are mapped to new fields and others will be mapped to text fields.

Cautions:

If you are a current Apache JackRabbit user and want to upgrade to the latest version of P6 EPPM, JackRabbit documents data will not migrate automatically. Refer to My Oracle Support's Knowledge Articles for information on manually migrating JackRabbit documents to Oracle Universal Content Management. Oracle recommends that you migrate the data before upgrading.
If you are a current jBPM user and want to upgrade P6 EPPM, workflows and reviews data will not be available. You should close all workflows and reviews that are in progress before upgrading. You cannot migrate any of this data to the latest version of P6 EPPM.

Release 6.2.1 or Earlier

If your current version is 6.2.1 or earlier, upgrade to version 7 prior to upgrading to a later version.

Back up your P6 EPPM database before beginning the upgrade process to ensure you will not lose any data due to unexpected problems. See Data Not Migrated During P6 EPPM Database Upgrade for details on what information will not upgrade.
Run the validate file located in your current Database folder of the P6 EPPM Release 7 physical media or download.
Convert your Methodology Management data to projects before you upgrade P6 EPPM. See Converting Methodologies to Projects and Creating a Project Template From Projects for manual migration instructions.
Run the P6 EPPM Configuration Wizard from the Release 7 media pack to upgrade your existing P6 EPPM database.
Test the new database to ensure that the upgrade succeeded.

Release 19 or Earlier

Release 8 or Later

Release 6.2.1 or Later

Release 6.2.1 or Earlier

Related Topics