We are exploring the option of archiving some of our PPMC data. We use an extensive amount of demand requests, and recently expanded into projects and proposals. On the demand side we probably see about 20000 tickets a month coming in. Over the past 5 years we've seen our database grow to an abnormal size and are facing some performance issues. We are taking steps to fix the performance by doing a rearchitecture and getting all new infrastucture. That was long overdue. However, we want to purge and archive some of this data. Does anyone know of a tool or used anything that works with HP PPMC? We are looking for something that can be a long term solution and would allow us to schedule a regular archival of data on a timed basis (monthly, etc.). Is there anything out there that is available?
We are doing the same thing here, but looking for a more permanent solution. We are looking for something that will allow both purging and archival on a scheduled basis. It would be great to leverage something HP supports. Otherwise, we are looking for any good / recommended database archival tool that we could fold into PPMC.