By Jeffrey Mcdaniel-Oracle on Jun 09, 2015
This blog will discuss upgrading from P6 Reporting Database version 3.0 all the way to Primavera Data Warehouse 15.1.
There are several releases between 3.0 and 15.1 (3.1, 3.2, 3.3). Generally upgrades are created for up to two releases back. There were a few major changes along the way which make it necessary to do intermediate upgrades if you are trying to come directly from 3.0 to 15.1.
In version 3.1 there was the addition of Slowly Changing Dimensions. In version 3.2 sp1 there was a switch in the type of partitioning from range to interval, also partitioning was now applied to the Slowly Changing Dimension tables. In 3.4 we introduced a new upgradeSchema path for upgrades which makes it possible to just upgrade the STAR schema with necessary alterations and then allow the normal ETL to run as it has been scheduled. This is in place of the upgrade.bat or .sh, which does full table backups and reinserts of history and other data. This upgrade process generally takes longer than a normal ETL run. In 15.1 there was the introduction of Unifier as a source into the data warehouse.
The ideal upgrade path if coming from 3.0 to 15.1 is:
3.0 --> 3.2 (to cover slowly changing dimension infrastructure)
3.2 --> 3.3 (to cover partitioning changes)
3.3 --> 15.1 (the easiest upgrade is to use Upgrade schema method. There are two to run depending on the version you are coming from - upgradeSchema33 and upgradeSchema34. In this path run upgradeSchema33)