1 |
Locate the NMSSv620-3.sql script. |
• |
Replace [DATABASENAME] with the name of the database (the name used on the system that connects to the database). |
1 |
Using SQL Query Analyzer or Toad® for MSS, load and execute the scripts in order. |
6 |
For PeopleSoft® users only, execute the appropriate archive table create scripts as documented below. |
If running PeopleSoft®, execute the NMSSv620ps8x.sql archive table create script. Modify the bracketed variables in a similar manner to the prior mandatory scripts.
Staging databases are used when migrating archive sets from your Stat® database to a PeopleSoft® database. A staging database is essentially a mini-PeopleSoft database with no application data and minimal tools data. Once created it should be maintained and tuned the same as other PeopleSoft databases in your environment.
Once you have created your AUD, Demo, or System database, execute the appropriate script.
• |
• |
• |
If running on DB2® execute StageDB2-ZOS-856.sql (for mainframe), or StageDB2-UNIX-856.sql (for AIX®/UNIX®). |
NOTE: Be aware of the following:
|
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center