Re: Archive old data
We selected a smaller time frame for the first time we turned on archiving. Just to see how long, how much impact it would have. So for the first pass, you might set the archive for to: Status = Closed AND 'status.history.time.closed' < "01/01/2004" How many records? How long did it take? Then you can decide if you should continue to do them incrementally or go ahead an do all of the rest at once. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Monday, June 02, 2008 8:46 AM To: arslist@ARSLIST.ORG Subject: RES: Archive old data Hi Paul and Shyam, We want to do something like these with our AR System App... We have tables/forms with records since year 2003... We want the data accessible (searchable) to the Archive Form. Our Archive Form will have only records with 'Status' = $Closed$ We are searching for solutions and/or suggestions to export a high quantity o records at the first time. Any tips? Thanks! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br <https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Shyam Attavar Enviada: sáb 31/5/2008 02:10 Para: arslist@ARSLIST.ORG Assunto: Re: Archive old data Paul, It depends whether you want the data accessible (searchable) or not. One of the things we have seen being done is to export the data into ARX files and the associated form definitions also and archived them on tapes for posterity. Another thing you can certainly do is to export the underlying DB tables (T, H and possibly B) as is (especially if you are on Oracle) and archive them on to tape. Not sure if this is exactly what you are looking for. HTH, -- Shyam - Original Message - From: "ARSsytem" <[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: Sent: Friday, May 30, 2008 2:31 PM Subject: Archive old data > Hi Listers, > > We are holding more than 7 years of data in our archive data forms > (which are only regular forms, not archive forms). We would like to > move part of them off line. Has anyone done that? Is there any white > paper for the best practice. Thanks! > > Regards > Paul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
RES: Archive old data
Hi Paul and Shyam, We want to do something like these with our AR System App... We have tables/forms with records since year 2003... We want the data accessible (searchable) to the Archive Form. Our Archive Form will have only records with 'Status' = $Closed$ We are searching for solutions and/or suggestions to export a high quantity o records at the first time. Any tips? Thanks! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br <https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Shyam Attavar Enviada: sáb 31/5/2008 02:10 Para: arslist@ARSLIST.ORG Assunto: Re: Archive old data Paul, It depends whether you want the data accessible (searchable) or not. One of the things we have seen being done is to export the data into ARX files and the associated form definitions also and archived them on tapes for posterity. Another thing you can certainly do is to export the underlying DB tables (T, H and possibly B) as is (especially if you are on Oracle) and archive them on to tape. Not sure if this is exactly what you are looking for. HTH, -- Shyam - Original Message - From: "ARSsytem" <[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: Sent: Friday, May 30, 2008 2:31 PM Subject: Archive old data > Hi Listers, > > We are holding more than 7 years of data in our archive data forms (which > are only regular forms, not archive forms). We would like to move part of > them off line. Has anyone done that? Is there any white paper for the best > practice. Thanks! > > Regards > Paul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Archive old data
Paul, It depends whether you want the data accessible (searchable) or not. One of the things we have seen being done is to export the data into ARX files and the associated form definitions also and archived them on tapes for posterity. Another thing you can certainly do is to export the underlying DB tables (T, H and possibly B) as is (especially if you are on Oracle) and archive them on to tape. Not sure if this is exactly what you are looking for. HTH, -- Shyam - Original Message - From: "ARSsytem" <[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: Sent: Friday, May 30, 2008 2:31 PM Subject: Archive old data Hi Listers, We are holding more than 7 years of data in our archive data forms (which are only regular forms, not archive forms). We would like to move part of them off line. Has anyone done that? Is there any white paper for the best practice. Thanks! Regards Paul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Archive old data
Hi Listers, We are holding more than 7 years of data in our archive data forms (which are only regular forms, not archive forms). We would like to move part of them off line. Has anyone done that? Is there any white paper for the best practice. Thanks! Regards Paul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"