Installation Guides › Upgrade Guide › Manual Upgrades › Manually Upgrade the Identity Manager Server › Manually Upgrade the Workflow Database

Previous Topic: Manually Upgrade the Identity Manager Server

Next Topic: Manually Export the Directories and Environments
Manually Upgrade the Workflow Database

As of CA Identity Manager r12.5, an updated version of WorkPoint Workflow was added to the installation. Update the workflow database to work with WorkPoint 3.4.2 after upgrading CA Identity Manager.

After updating the workflow database, you can continue to use the workflow processes that you developed in WorkPoint 3.3.

To upgrade to WorkPoint 3.4.2

  1. Run the wp331_to_wp34_cnv_step1.sql script to create the new tables for Workpoint 3.4 and to add the new columns to the end of old tables.

    This script also inserts rows into the WP_*_TYPE tables as needed.

  2. Run the wp331_to_wp34_cnv_step2.sql script to create the stored procedures required to convert the data.
  3. Run the wp331_to_wp34_cnv_step3.sql script to convert the text data to the new columns.

    This script also populates the new WP_BULK_DATA table from the old WP_BULK_STORAGE table.

  4. Run the wp34_20060927_add.sql script to create the new tables for Workpoint 3.4.20060927.

    This script also inserts rows into the WP_INI and WP_*_TYPE tables as needed.

  5. Run the wp34_20070625_add.sql script to create the new tables for Workpoint 3.4.2.20070625. This also inserts rows into the WP_INI and WP_*_TYPE tables as needed.
  6. Run the wp342_20071218_add.sql script to create the new tables for Workpoint 3.4.2.20071218.

    This script also inserts rows into the WP_INI and WP_*_TYPE tables as needed.

  7. Save all changes to the database.

Note: The WorkPoint scripts are located in Administrative Tools folder\Workpoint\database. The Administrative Tools are placed in the following default locations: