Re: Replication Question

Rob I was not actually intending to answer you question as we do not use = Enterprise Replication at this site. We have our own trigger based = multi-way replication which we built prior to the availability of CDR. = (And have only upgraded to 7.23 last week). But since no-one who is = actually using it appears to have replied to you, then here is my opinion. My understanding , having reviewed the documentation, is that the purpose = of ER is to allow multi way continuous data replication at a table level. IE you do not have to copy the whole database, just the bits you want. IE, yes to your question, if you are wanting to synchonise data between 2 = or more *informix* databases then you do not have to buy a third party = product, ER will do the job for you. ER works off the transaction logs and as such does not affect user = response on the operational databases. I suggest to you that you review the documentation and give it a go. Although ER has a number of methodologies for resolving collisions, where = possible if you handle these in your business rules you will save yourself = a lot of strife. If each office is only accessing it's own dataset then I = do not think that you will have any problems. I am not sure whether the resolution of ER goes as far as a column level = or just row level, IE, if someone updates customer name, while someone on = another site simultaneously updates customer address, (both attributes in = this hypothetical case of customer) is this a collision or not? Perhaps someone who is actually using ER could answer. Cheers Peter Tashkoff <tashkop@iname.com> Zespri International Limited Std Disclaimers Apply All rights reserved. No party may use this document to vilify another. Zespri New Zealand Kiwifruit, The World's Finest >>> Herve Delattre <herved@worldnet.fr> 6/01/98 21:33:44 >>> Take a look at Praxis International OmniEnterprise. http://www.praxisint.com=20 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=20 >solution to set up their information system. The software they want to=20 > 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=20 >office and use replication to update the databases with High=20 >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=20 >to keep telephone bill as low as possible.=20 > > My questions are: > - Does anyone have a solution ?=20 > - 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=20 > 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 !!! >=20