Re: Replication Question

Take a look at Praxis International OmniEnterprise. http://www.praxisint.com Regards, Herve Delattre Rob Prop <rprop@concepts.nl> wrote: >I have a question regarding Data Replication. One of our clients has 2 > offices in 2 different cities. They want to know whats the best >solution to set up their information system. The software they want to > use is a system we developed in 4GL. They really want one central >database. Both offices use (including insert and update) the same >database, but other datasets. (Normally each office only uses it's > own data). Their question was: Can we set a database server in each >office and use replication to update the databases with High >Availability Data Replication (HADR). My answer was NO !! > What I know of data replication is that only one server can be updated, > the other one is readonly. It also isn't wise to use HADR over > telephone (ISDN or not) lines. They wanted this because when one server > fails they have the possibility to work on the other. They also wants >to keep telephone bill as low as possible. > > My questions are: > - Does anyone have a solution ? > - Can this be done with Enterprise Replication ? > - Is it possible to synchronise the databases at night ? > - Is it wiser to set up 2 different env. with a backup on the > remote machine ? > - Which software do I need, can I use OWGS or does I need ODS ? > - Do I need exra software (for the replication etc.) ? > > Thank you very much in advance, help me I'm stuck !!! >