Upgrade Guide › Upgrading Databases › Upgrading a 6.0 Database › SQL Server: Post-Upgrade Change To Event Participant Table › 1. Run the Post-Upgrade Pre-Flight Check › Example 1: Pre-Flight Check All OK

Example 1: Pre-Flight Check All OK

In this example, the script output indicates all necessary conditions are OK. You can proceed with the table update.

**********************************************************************
*** Pre-flight Check has started
**********************************************************************

Participant address columns:
OK:  Wgn3EventParticipant.addressuid1 is currently defined as optional
OK:  Wgn3EventParticipant.addressuid2 is currently defined as optional

xp_cmdshell and BCP utility:
OK:  xp_cmdshell is enabled on this server
OK:  xp_cmdshell will run under this database account
OK:  BCP successfully wrote to C:\DBUpgradedata\bcp_pf_ep_data.txt

Free disk space:
OK:  Available disk space in C:\DBUpgradedata exceeds required disk space
Available disk space: 2933 Mb
Required disk space:  1 Mb

Time estimate:
Total time required to modify Wgn3EventParticipant table: 2800mS
This is our best estimate of how long it will take to upgrade your database.
Please allow for this when planning your CMS upgrade.

bcp command:
This Pre-flight Check uses this command to copy database records 
to bcp_pf_ep_data.txt.
For diagnostic purposes, the output is piped to bcp_pf_ep_data.log.bcp.
"SELECT TOP 432 * FROM [WGN_TA-RL-WS2].dbo.Wgn3EventParticipant" 
  queryout C:\DBUpgrade\bcp_pf_ep_data.txt -N -S "TA-RL-XP" 
  -T >C:\DBUpgrade\bcp_pf_ep_data.log

**********************************************************************
*** Pre-flight Check is complete
**********************************************************************