In this section:
Whenever a new release of Performance Management Framework is introduced, refer to this section of the manual for special migration instructions.
Back up any existing data that you are currently using.
Note: It is important to back up existing data marts. If the migration procedure is not completed as expected, you will still have working copies.
If you are using a PMF data mart that is V5 level or higher, PMF will be able to autonomically upgrade its data mart. When logged in as an administrator, PMF will check to see if your data mart is current. If it is out of date, you will be prompted to allow it to be upgraded.
This topic describes how to migrate Performance Management Framework from Release 4.2 to Release 5. Migrating from PMF 4.2 to 5 consists of two procedures, running the PMF conversion utility program and synchronizing the dimensions in your underlying database with the WebFOCUS metadata files provided with PMF 4.2.
PMF 5 is delivered with a database-specific migration script that converts your existing PMF 4.2 database structures to PMF 5. You must run the script using an appropriate tool for your RDBMS. For example, for Oracle you would likely use SQL*Plus, while for SQL Server, you would likely use the Query Manager.
The following instructions are specific to SQL Server.