March 9, 2009 at 9:16 am
What I want to do is restore a backup from my production box to my dev and tst boxes. But I am not sure what will have to be changed in order for this to work. I was hoping for a PeopleSoft/MSSQL DBA that has done this and could help in the right direction.
March 9, 2009 at 9:19 am
I'll forward this Thread to our PeopleSoft Admin. All I do is restore the production databases, she takes care of evrything else.
March 9, 2009 at 10:02 am
After our production backup is restored to our test server as our test database we run some sql to adjust some necessary values. The sql will be different depending on your application (HCM, FMS, etc) and your version and even your database and version. Our script for HCM 9.0 includes the PeopleSoft provided connect2005.sql, grant.sql (both edited with our security information), and appmsgpurgall. We also have to adjust some configuration to be appropriate with the test environment instead of production.
UPDATE PSOPTIONS
SET GUID = ' ', SYSTEMTYPE = 'STS';
We clear out the process monitor queues (PSPRCSRQST, PSPRCSQUE), change our security options (PSSECOPTIONS), our reporting node (PS_CDM_DIST_NODE), our REN cluster (PSMCFRENURLID), trusted nodes (PSTRUSTNODES), integration broker information (PSMSGNODEDEFN, PSIBRTNGDEFN, PSRTNGDFNPARM, PSIBRTNGSUBDEFN, PSNODEURITEXT, PSAPMSGDOMSTAT) and our email addresses (PSUSEREMAIL, PS_ROLEXLATOPR, PSOPRDEFN, PS_EMAIL_ADDRESSES, PS_HRS_APP_EMAIL) to prevent test email from being set to real employees.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply