Upgrade Guide › Upgrading Databases › Database Upgrade Procedure › SQL Server: Post-Upgrade Table Change › Install the SPs Into Your Database

Install the SPs Into Your Database

To install the SPs into your database

1. Run a script to install the required SPs. This script is wgn_post_upgrade_install.sql. When you upgrade your CMS, it is installed automatically into the \System\Scripts\MSSQL subfolder of the CA DLP installation folder

   Run the following command on the CMS:

   wgninfra -exec 
   wigan/schema/Schema RunScript <path>\wgn_post_upgrade_install.sql
   

   where <path> is \Scripts\MSSQL.

   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. Run the pre-flight check.

More information:

Run the Pre-Flight Check