I am not clear on what your spefic question is and its context.  In general we have a number of best practices that should be followed when moving data from a production system.  Please see PDN PegaRULES Database topics including purging and archiving: https://pdn.pega.com/browse/prpc-topics/pegarules-database.

Lu

The Pega Academy Support Team

Hi Murali,

For your requirement as stated above that you want to create zip file containing  pdf files and xml metadata, whether the pdf files are attachments of the work object and what would be the content of xml metadata whether it is case content?

you can write an agent activity run after end of business hours may be 6pm daily and get the list of cases created on that day i.e. pxcreatedatatime and iterate on each of case from the list and open each case and get the attachment available on the case and store in the server directory, similarly for xml data.

After all the cases on that day are completed i.e. after that iteration completes in that activity write code for creating zip file.

Create a new Activity

this new actvity should get the instances of Link-Attachment & Data-WorkAttach- of the work object using pzInsKey

after building the required pagelist, please refer step #9 of ootb activity RULE-OBJ-ACTIVITY RULE-ADMIN-PRODUCT CREATEZIPFILE

 save this generated zip file into external system

may be creating a FSO object would help us to save the file at desired location

Will there be any caveat as we expect the size to be in between 200 to 300 MB?

not sure...