245 total views, 9 views today

How to do Primavera Professional Database Upgrade

The Primavera professional comes with Database upgrade utility. The upgrade utility does not install with the standard installation procedure; we need to enable the utility manually during the Primavera Professional installation. Let’s assume you have installed the Primavera Professional already and you need to have that utility to further upgrade or create a new Professional schema.  In that case, follow the instruction for how to include the Primavera Professional Database upgrade utility in the existing installation. If you are going to install newly, then refer the step 2 and skip the remaining steps.

 

1. Unzip your P6 Professional setup and double click on the setup.exe

 

061117_1540_HowtodoPrim1 How to  do Primavera Professional database upgrade

 

2. Expand Primavera P6 Professional >> P6 Professional Common Components >> Tools for P6 professional Online >> P6 Professional Standalone upgrade Utility

 

061117_1540_HowtodoPrim2 How to  do Primavera Professional database upgrade

 

 

3. Click Modify

 

 

061117_1540_HowtodoPrim3 How to  do Primavera Professional database upgrade

4. Uncheck the checkbook Run Standalone Upgrade Utility and click Ok

061117_1540_HowtodoPrim4 How to  do Primavera Professional database upgrade

 

 

5. Once the setup was done. Go to the Primavera Installation folder\ Database\scripts\install\PPM_<VERSION>; Execute the script manual_script_before_upgrade.sql as SYSBA.

 

Note: This step is only for Oracle database

 

061117_1540_HowtodoPrim5 How to  do Primavera Professional database upgrade

 

 

6. Go back to the Professional installation folder \\ Database and edit the dbsetup.bat file. Set the JAVA_HOME variable point to your java directory. Make sure the java version is tested version of Primavera P6

 

061117_1540_HowtodoPrim6 How to  do Primavera Professional database upgrade

 

 

7. Choose Upgrade an existing database and select the server type

 

 

061117_1540_HowtodoPrim7 How to  do Primavera Professional database upgrade

 

 

8. Input your SYSTEM database information and click Next (Oracle Database)

 

 

061117_1540_HowtodoPrim8 How to  do Primavera Professional database upgrade

 

 

9. Input your Primavera ADMUSER schema details

 

 

061117_1540_HowtodoPrim9 How to  do Primavera Professional database upgrade

 

 

10. Once upgrade is done click Finish

 

 

061117_1540_HowtodoPrim10 How to  do Primavera Professional database upgrade

 

That’s it. We have completed the Primavera Professional database upgrade. Please leave your comment below for any questions 🙂 

govindan How to  do Primavera Professional database upgrade
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
govindan How to  do Primavera Professional database upgrade
Connect me
Like us on Facebook.
Connect!