Upgrade Guide › Upgrading Databases › Upgrading a 6.0 Database › SQL Server: Post-Upgrade Change To Event Participant Table › 3. Install the SPs Into Your Database

3. Install the SPs Into Your Database

You must run a script to install the required SPs. This script is wgn_post_upgrade_install.sql. When you upgrade your CMS, this script is installed automatically into the \System\Scripts\MSSQL subfolder of the CA DataMinder installation folder

To install the SPs into your database

1. Run the following DOS command on the CMS:

   wgninfra -exec wigan/schema/Schema 
     RunScript \Scripts\MSSQL\wgn_post_upgrade_install.sql
   

   This script installs these SPs into the CMS database.

   wgn_post_upgrade.sql 
   

   This script runs the entire post-upgrade table modification as a single procedure.

   wgn_post_upgrade_1.sql 
   

   This script runs the first part of the post-upgrade table modification. It stops at the point where all participant records have been copied to a file and before the table is truncated.

   wgn_post_upgrade_2.sql
   

   This script runs the second part of the table modification. It resumes at the point where Wgn3EventParticipant is truncated. It then makes the necessary column changes, and copies the participant records back into the table.

2. Check the log files to verify that the installation was successful.

More information:

1. Run the Post-Upgrade Pre-Flight Check