Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Script for Environment Refresh

Highlighted
James++
Regular Collector

Script for Environment Refresh

Hello Friends,

Can anyone provide me the step for performing the environment (DB) refresh.

One more query do we need to run any HP PPM scripts (like giving the user grants etc.)after droping the schema.

Thanks
2 REPLIES
Erik Cole
Honored Contributor

Re: Script for Environment Refresh

We just "restore" from a recent backup of prod...I don't think any special scripts or anything are needed.
Alexandru Saven
Regular Collector

Re: Script for Environment Refresh

hello,

the steps are as follows (I am using this sequence since I use one PPM dump in multiple environments:
- do NOT drop the schema;
- disable all foreign keys and triggers;
- truncate all tables;
- import the dump;
- recompile invalid objects;
- calculate statistics;
- reset the PPM password(s) using kEncrypt.sh.

let me know if this helps.

cheers
alex
//Add this to "OnDomLoad" event