Upgrade from Dimensions CM 2009 R2 and 12.x‌

To upgrade from Dimensions CM 2009 R2 and 12.x:

Run the latest 14.x Dimensions CM installer.
Run the Versioned Repository Schema (VRS) upgrade utility to upgrade the data in your RDBMS.
To prevent issues with data that was created with a pre-14.1.x release of Dimensions CM:
- We recommend that users who have any pending changes deliver or check them in before you start the upgrade.
- Run the UPDATE command after the upgrade to 14.x to upgrade the metadata in your work areas.

The VRS upgrade retains all the existing project structure, project history, and baseline data. This avoids the need to upgrade all projects and baselines and ensures that an error during upgrade does not result in a loss of data. However, database size may increase dramatically as it contains both the old and new data. Before performing an upgrade you should increase the space allocated for PCMS_DATA by at least 50% and the space allocated for PCMS_IDX by at least 100%.

To prevent poor performance, recompute database statistics after an upgrade. If you choose to perform a series of partial upgrades, recompute statistics after each partial upgrade.

After all projects and baselines have been upgraded, you can drop the tables containing the pre-upgrade data. Back up and create an export of these tables (or the entire database) before dropping them:

XII_WS_FILES

XII_WS_DIRS

XII_PSH_REQ_RELS

XII_PSH_PSH_RELS

XII_PSH

XII_PREV_CHANGES

XII_PART_PART_RELS

XII_PART_ITEM_RELS

XII_MIGRATED_CHANGES

XII_ITEM_SETS

XII_DP_ITEMS_SETS

XII_BASELINE_ITEM_FILES

XII_BASELINE_ITEM_DIRS