Upgrade Guide › Upgrading Databases › Upgrading a 6.0 Database › How to Upgrade a 6.0 Database › 1. Run the Pre-Upgrade 'Participant Address' Pre-Flight Check

1. Run the Pre-Upgrade '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 DataMinder 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 DataMinder distribution media:

\Support\Upgrade12\Oracle

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

@wgn_pre_upgrade_pfc