Hi Vikram, You could try DB triggers to replicate data in tables of other DBs.
Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 On Fri, Mar 11, 2011 at 3:42 PM, vikram_k <vk0073...@techmahindra.com>wrote: > Hi listers, > > Greetings, > > I have a new challenge thrown at me.. now the performance of the system is > good enough (if you remember my tiring question about ARS performance and > huge queries) now I have been asked to find a way to keep 2 application > servers in sync at real time. And what I could think of is to introduce DSO > to into the picture. So here it goes: > > 1) Is it best to use DSO to keep 2 Application servers in sync all real > time. > 2) Both the application servers are replicas of each other but > geographically located. > 3) The ARS application is completely customized with 350+ forms to be > managed in sync. > 4) Also DSO is to be used to archive data from one of the servers into the > other which will be used as just an read only reporting server. > 5) Both the servers are ARS 5.0.1 :) > > So I would really appreciate if you can help me through this as well as you > did in my previous endavour. > > My questions : > > 1) Is it reliabe to use DSO in this big context? > 2) What all factors do I have to keep my eyes on while doing this? > 3) What is the performance hit that if at all one can expect? > 4) Any specific setting that can be implemented to keep the performance up? > > I guess this is a nice learing experience for someone like me and would > like > any help possible from you guys. > > > Thanks in advance > > Regards, > Vikram. > -- > View this message in context: > http://old.nabble.com/Using-DSO-to-sync-two-AR-Servers-tp31123715p31123715.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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"