Project and Portfolio Management Practitioners Forum
cancel

Re: Archiving PPMC Data

Highlighted
Kevin Abram
Trusted 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
Acclaimed 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
Acclaimed 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