topic Data Archiving in Application Development and Automation Discussions

Data Archiving

Former Member — Mon, 06 Jul 2009 15:24:33 GMT

Hai Friends,

We have a Z table which contains around 400000 data. i want to archive this. is this possible only with the BASIS team or any other altenatives. if so explain me the process.

Re: Data Archiving

Former Member — Mon, 06 Jul 2009 15:59:49 GMT

Hi,

It really depends on what your reasons are for archiving, do you need to free up space in the database or just improve the performance of these table by removing old entries?

If you just need to improve performance then create a copy of your Z table definition and copy 'out of date' records to this copy table. Create a report than can run periodically to copy records from you current table to the copy based on some criteria.

If you need to free up space in the database you will have to use whatever archiving strategy is in place on your system currently.

Regards,

Nick

Re: Data Archiving

Former Member — Wed, 08 Jul 2009 05:02:07 GMT

I dont think there is another solution then either to delete the records which are not required , to free up the space...or its better to create a new Ztable.

Else contact Basis team at your end if they have mechanism for table data archiving

Thanks!

Prashant