Upgrading pre-14.x data ‌

If you are upgrading from a pre-Dimensions CM 14.x release you must upgrade your data to use the new Versioned Repository Schema (VRS). The upgrade is required to populate the VRS schema for the existing streams, projects, and baselines.

We recommend that you first upgrade active, recently used projects, streams, and baselines so that your users can resume work immediately. Then upgrade the rest of the data. Dimensions CM operates normally while the upgrade utility runs in the background.

You can use the following methods to perform the VRS upgrade:

• The Versioned Repository Schema Upgrade GUI utility

• The dmdba command line

Use the VRS upgrade utility‌

1. Launch the Versioned Repository Schema Upgrade GUI utility.

   • Windows: From the Start menu, select Dimensions CM <version> > Versioned Repository Schema Upgrade.

   • Unix:

     1. Change directory to the Dimensions CM root directory.

     2. Run the dmprofile environment script.

     3. Call the vrsupgradeui script.

2. In the login dialog box specify a schema name, schema password, and DB connection for the database you want to upgrade. Click OK.

   The Versioned Repository Schema Upgrade utility opens. It may take some time for the data to be loaded from the database. Navigate between the tabs to display the projects, streams, and baselines that can be upgraded.
   

3. By default all objects are selected initially. To modify the list of objects to be upgraded apply the following filters:

   • In the Filter box enter a value and from the list select one or more of these filters:

     • ID

     • Last Updated Date

     • Items

   • Select the From and/or To options and specify a date range.

   Tip: Use the right-click menu to expand, collapse, check, and uncheck objects and trees.

   Caution: By default, all objects are selected. When you apply filters, all selected objects are upgraded, not just those displayed in the filter list. Deselect objects that you do not want to upgrade.

4. To upgrade all the selected objects click Upgrade.

5. Click the Logging tab to display details of the upgrade progress.

6. When the upgrade is completed click Finish.

Use dmdba to upgrade to VRS‌

Connect to the base database using the dmdba utility:

dmdba DB_name/db_password@db_connection

To upgrade projects and streams:

Run the upgradevrs command. You must use a pattern or list to specify the projects and streams to be upgraded:

• Project name or pattern: PRODUCT:PROJECT,PRODUCT:%, %

• List: specify a file containing a list projects and streams in /B[ULK_FILE]=filename

  The file should have one stream or project per line followed by '/'.

To upgrade baselines:

Run the upgradebln141 command. You can use a pattern or list to specify the baselines to be upgraded:

• Baseline name or pattern: PRODUCT:BASELINE1, %

• List: specify a file containing a list of baselines in / B[ULK_FILE]=filename

  The file should have one baseline per line followed by '/'.

To prepare streams for use in CM Bridge:

Run the upgradecmbr command. You may use a pattern or list to specify the projects and streams to be upgraded:

• Project name or pattern: PRODUCT:PROJECT,PRODUCT:%, %

• List: specify a file containing a list projects and streams in /B[ULK_FILE]=filename

  The file should have one stream or project per line followed by '/'.

Compute statistics

After completing the VRS upgrade, we recommend that you compute database statistics. For details, see Recalculate database statistics ‌.‌