Stat 6.2 - Install Notes

NMSSv620-3.sql

Execute the scripts

Execute required PeopleSoft scripts (PeopleSoft Only)

If running PeopleSoft®, execute the NMSSv620ps8x.sql archive table create script. Modify the bracketed variables in a similar manner to the prior mandatory scripts.

Create a staging database (PeopleSoft Only)

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.

Depending on the volume of objects moved or number of PeopleSoft tools versions you are supporting, you may decide to have multiple staging databases. This section describes how to create a staging database in Stat.

The staging database can either be a PeopleSoft demo (DEMO) or system (SYS) database. For detailed instructions on creating this database, please see your PeopleSoft Installation and Administration Guide. Financial databases in particular have a large number of tables used for sorting data. These tables can be dropped from the staging database.

Once you have created your AUD, Demo, or System database, execute the appropriate script.

These scripts complete the creation of a staging database. It is recommended that you create at least two staging databases. You may need to alter this script to match your platform.

NOTE: Be aware of the following: • For each staging database you define in Stat, make sure the Reload Last Project at Startup option is deselected for that database in PeopleSoft App Designer. Stat may have difficulty auto-migrating objects from the staging database if this option is selected. • When migrating archive sets, the base language of the staging database must be the same as the base language of the environment that the archive set came from (i.e., the source). The base language option is specified in the PeopleSoft Environment Connection Maintenance table. For more information, see the Stat System Administration Guide, Chapter 4, General Maintenance Tables.