Re: Using SQR to Update PeopleSoft Recodr Definitions

["Blakeslee, Andy" <ALBlakeslee@HOMELOAN.COM>]

I have been through several PeopleSoft upgrades, and also wanted to write an
sqr to solve this problem.  I am currently doing an upgrade of ADP's HRizon,
which is basically a slightly modified version of PeopleSoft (several
versions behind).  They have an approach to this problem that I kind of like
(proactive as opposed to reactive).  They provide an excel macro that asks
some key questions (# of employee's, pay cycles, etc.) and then determines
the appropriate sizes for all the tables and tablespaces.   You then
generate a csv file, which is read by an sqr program that updates the
PeopleTools, er, HRizonTools, tables BEFORE generating the Create and Alter
Scripts.

> -----Original Message-----
> From: Brian O'Neill [SMTP:boneill@TGTSOLUTIONS.COM]
> Sent: Thursday, February 11, 1999 12:50 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Using SQR to Update PeopleSoft Recodr Definitions
>
> This is a primarily a question for PeopleSoft/Oracle/SQR users.
>
> Has anyone used SQR to update the PeopleSoft Record definition (Tools)
> tables based on the data in the System Catalogue tables?  Specifically,
> INIT
> and NEXT extent information.
>
> I am working at a number of client sites where the DBA's have allowed the
> systems to become WAY out of sync. This is quite a headache during
> upgrades.
>
> We are in the process of writing the SQR to complete the synchronization
> and
> were wondering if there were any traps, tricks or other alternatives?
>
> Brian