After you have created a copy of your Stat® production database (test database), you are ready to begin the test upgrade.
• |
For Oracle®, the scripts can be run using SQL*Plus or Toad™ for Oracle. |
• |
For SQL Server®, execute the appropriate upgrade scripts using Toad for SQL Server or SQL Query Analyzer. Do not use other third-party tools. |
The upgrade scripts for Stat 6.2.0 running on Oracle® are located in <target directory>\Scripts\Oracle\Upgrade.
IMPORTANT: To upgrade to Stat 6.2.0, you must be using Stat 5.7.x, 5.8.x, 6.0.x , or 6.1.x. |
1 |
For Stat 5.7.x PeopleSoft users only, locate the script UORA580ps854-855.sql under Upgrade_to_5.8 folder. |
2 |
3 |
4 |
5 |
6 |
Recompile any invalid PL/SQL modules in the database by running the script utlrp.sql located in <ORACLE_HOME>/rdbms/admin directory. |
The upgrade scripts for Stat 6.2.0 running on SQL Server are located in <target directory>\Scripts\MSSQLServer\Upgrade.
IMPORTANT: To upgrade to Stat 6.2.0, you must be on Stat 5.7.x, 5.8.x, 6.0.x , or 6.1.x. |
1 |
For Stat 5.7.x PeopleSoft® users only, locate the script UMSS580ps854-855.sql under the Upgrade_to_5.8 folder. |
2 |
For Stat 5.7.x users only, locate the script UMSSv570-580.sql. |
3 |
4 |
5 |
• |
• |
• |
If running on DB2® execute StageDB2-ZOS-856.sql (for mainframe), or StageDB2-UNIX-856.sql (for AIX®/UNIX®), if not previously run. |
1 |
Locate the StageORA856.sql script. |
• |
[OWNER/PWD@DATABASENAME] Replace with the correct values for the PeopleSoft® schema owner/password and staging database. |
• |
[SPOOLPT] Replace with the directory for the session log. |
• |
[PTAPP] Replace with the tablespace for the staging table |
• |
[PSINDEX] Replace with the tablespace for the staging table indexes |
1 |
Locate the StageMSS856.sql script. |
2 |
Find and replace the variable [DATABASENAME] with the name of the database. |
3 |
Using Enterprise Manager, go into SQL Server® Analyzer from Tools on the menu bar. |
4 |
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center