From the application level required a lot of activities (Filter, Escalation, Form archive). However, this can be done from the database level using the replication tools (i.e. Oracle Streams processes) or copy, export and import (i.e. tables such as Txx ,Hxx and Bxx).
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Viki_kulkarni Sent: Monday, January 31, 2011 7:02 AM To: arslist@ARSLIST.ORG Subject: Re: Data Archiving to Vendor form!! will it work? Yes I have been thinking in the same way but the DBA team is stressing to put it on a different database due to space issues at least thats what they reason. I was trying to do the same task using a view form but facing issues in push fields well lets see how things work out. patchsk wrote: > > why do you want to create vendor forms. > You can just save as original form with a different name and use that > as archive data holder. > You can write the escalation to do a push field create entry to the > new form and a delete entry on the old form. > > On Jan 28, 6:54 am, Viki_kulkarni <vk0073...@techmahindra.com> wrote: >> hi Listers, >> >> We are trying to enable archiving on ARS 5.01. Yes we are aware that we >> dont >> have archiving functionality on ARS 5.0.1 (correct me if wrong). So here >> is >> how I am planning to do it and would like you guys to have a look at and >> with all the experience you have it will be great review. >> >> The purpose of archiving is to increase performance while searching and >> to >> reduce database size. >> >> Hence what I am suggesting is to create a new database with tables same >> as >> in AR database. (the T Tables). Then I will create vendor forms for all >> the >> forms that I need to archive and map them to the new database tables that >> I >> have created similar to the AR T tables using ARDBC plugin. Now I will >> run >> an esclation that will move the records from AR server forms to the new >> vendor forms by a special user AR_ARCHIVER just as it does with the >> inbuilt >> archiving.All other users will have only read only access to the archive >> form as per the inbuilt functionality. >> >> Now this will reduce the number of records on the AR Server forms and >> move >> it to the archive vendor form. (At least that is the idea) >> >> Now I am aware that I will need to keep an eye on all the changes that >> happens to the base form in terms of field addition and need to replicate >> on >> the vendor archive form. But thats ok with us as there wont be any change >> we >> guess. >> >> So let me know if you guys think this will work? I am currently trying >> for a >> small POC for the same will update for the same once I pass/fail and what >> would be the pros and cons for the same. >> >> Just trying to think OOTB :) >> >> Thanks, >> Viki >> -- >> View this message in >> context:http://old.nabble.com/Data-Archiving-to-Vendor-form%21%21-will-it-wor... >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> ___________________________________________________________________________ >> ____ >> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org >> attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > -- View this message in context: http://old.nabble.com/Data-Archiving-to-Vendor-form%21%21-will-it-work--tp30786586p30803749.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
