Upgrade Guide › Upgrading Databases › Database Upgrade Procedure › Database Upgrade Overview › Before Upgrading Your CMS: Run the ‘participant address’ Pre-Flight Check

Before Upgrading Your CMS: Run the ‘participant address’ Pre-Flight Check

Before you upgrade your CMS, you must run a pre-flight check script, wgn_pre_upgrade_pfc.sql.

This script estimates how long it will take, as part of the CMS upgrade, to update the event participant records and migrate them to the new database table. The Oracle pre-flight check also estimates how long the post-upgrade changes to the Wgn3EventParticipant database table will take. You can use these estimates to plan your CMS upgrade. To run wgn_pre_upgrade_pfc.sql:

SQL Server

Find this script in the following folder on your CA DLP distribution media:

\Support\Upgrade12\MSSQL

Open and execute this file in SQL Server Management Studio. To do this, use a login with the sysadmin role (for example, sa).

Oracle

Find this script in the following folder on your CA DLP distribution media:

\Support\Upgrade12\Oracle

Then, using SQL Plus connect to the CA DLP database as the CA DLP schema owner (typically APMOWNER on version 6.0 CMSs) and run this command:

@wgn_pre_upgrade_pfc

More information:

Modify the Event Participant Table