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

Re: Archiving PPMC Data

Highlighted
Kevin Abram
Occasional Contributor

Re: Archiving PPMC Data

Has anyone successfully developed a solution which archives data from the PPMC database based upon some criteria such as Request or Time sheet Creation Date. We have been using PPMC since version 6 and the Database contains a lot of information that is way out of date. Instead of constantly adding more disk space, we would like to develop some type of strategy to remove old data from the database. I would appreciate anyone's suggestions on this matter.

 

 

2 REPLIES
Utkarsh_Mishra
Honored Contributor

Re: Archiving PPMC Data

For archiving we have created a seperate PPM instance, which hold the archival data.

 

This instance is refreshed in every 6 months using the Data pump scripts.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Celil
Esteemed Contributor

Re: Archiving PPMC Data

Hi Utkarsh,

 

Could you please publish your data pump script with us?

 

Regards,

Celil

Celil

IT Governance Professional
& PPM Solution Architect
//Add this to "OnDomLoad" event