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 <[email protected]> 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"
