offline replication

Posted in 2003

Summary

A developer needed to replicate a central Informix 9.20 database (HP-UX) out to remote regional sites that also update data locally, but the sites have no network connection to the main server. Respondents first suggested built-in Enterprise Replication (not HDR), but when the poster clarified that he needs a transportable copy on tape/disk rather than a live connection, Madison Pruet said ER won't do that; the only approach he knew was insert/update/delete triggers writing rows plus operation and timestamp/serial into a staging table, then unloading that table and applying it at the targets. No further discussion follows.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Platform-Specific Issues

Fernando Garcia — Fri, 04 Jul 2003 16:04:31 — source: IIUG Forums & Mailing Lists

Hi. We're developing a database application for administrative tasks and we need to replicate our main database thru a few sites. The problem is that those sites won't be on-line and need to insert/update regional data (it's not necessary that the new data are available immediately). Does anybody knows a technique to do this painless? We are thinking about an application solution (keeping track of new or modified records to distribute on every site) but we think this is problematic and maybe dangerous in some degree. I already read the "Administrator's Guide" for any clue, but I didn't find anything similar. Our main server is a HP 9000 machine with HPUX 11.0 and Informix 9.20D5. Every other site will work with a small server (Intel) using Linux and a newer version of Informix. We're developing on Windows. I hope that somebody can help us. Thanks.

↪ replying to Fernando Garcia

Colin Bull — Sat, 05 Jul 2003 21:48:47 — source: IIUG Forums & Mailing Lists

I beleive Enterprise Replication that is built into IDS will do all this for you. Why re-invent the wheel? Colin Bull c.bull@videonetworks.com > -----Original Message----- > From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On > Behalf Of Fernando Garcia > Sent: 04 July 2003 17:05 > To: ids@iiug.org > Subject: offline replication [1499] > > > Hi. We're developing a database application for > administrative tasks and we need to replicate our main > database thru a few sites. The problem is that those sites > won't be on-line and need to insert/update regional data > (it's not necessary that the new data are available immediately). > Does anybody knows a technique to do this painless? We are > thinking about an application solution (keeping track of new > or modified records to distribute on every site) but we think > this is problematic and maybe dangerous in some degree. > I already read the "Administrator's Guide" for any clue, but > I didn't find anything similar. > Our main server is a HP 9000 machine with HPUX 11.0 and > Informix 9.20D5. Every other site will work with a small > server (Intel) using Linux and a newer version of Informix. > We're developing on Windows. > I hope that somebody can help us. Thanks. >

↪ replying to Colin Bull

Madison Pruet — Sat, 05 Jul 2003 23:54:29 — source: IIUG Forums & Mailing Lists

Yep... "Colin Bull" <c.bull@videonetw To: ids@iiug.org orks.com> cc: Sent by: Subject: RE: offline replication [1506] forum.subscriber@ iiug.org 07/05/2003 04:48 PM I beleive Enterprise Replication that is built into IDS will do all this for you. Why re-invent the wheel? Colin Bull c.bull@videonetworks.com > -----Original Message----- > From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On > Behalf Of Fernando Garcia > Sent: 04 July 2003 17:05 > To: ids@iiug.org > Subject: offline replication [1499] > > > Hi. We're developing a database application for > administrative tasks and we need to replicate our main > database thru a few sites. The problem is that those sites > won't be on-line and need to insert/update regional data > (it's not necessary that the new data are available immediately). > Does anybody knows a technique to do this painless? We are > thinking about an application solution (keeping track of new > or modified records to distribute on every site) but we think > this is problematic and maybe dangerous in some degree. > I already read the "Administrator's Guide" for any clue, but > I didn't find anything similar. > Our main server is a HP 9000 machine with HPUX 11.0 and > Informix 9.20D5. Every other site will work with a small > server (Intel) using Linux and a newer version of Informix. > We're developing on Windows. > I hope that somebody can help us. Thanks. >

↪ replying to Fernando Garcia

Support Informix — Mon, 07 Jul 2003 06:04:39 — source: IIUG Forums & Mailing Lists

Yes, search in the Informix guides for Enterprise Replication, that's what you needs ! (don't confuse it with High Data Replication) Yves -----Original Message----- From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org] Sent: vrijdag 4 juli 2003 18:05 To: ids@iiug.org Subject: offline replication [1499] Hi. We're developing a database application for administrative tasks and we need to replicate our main database thru a few sites. The problem is that those sites won't be on-line and need to insert/update regional data (it's not necessary that the new data are available immediately). Does anybody knows a technique to do this painless? We are thinking about an application solution (keeping track of new or modified records to distribute on every site) but we think this is problematic and maybe dangerous in some degree. I already read the "Administrator's Guide" for any clue, but I didn't find anything similar. Our main server is a HP 9000 machine with HPUX 11.0 and Informix 9.20D5. Every other site will work with a small server (Intel) using Linux and a newer version of Informix. We're developing on Windows. I hope that somebody can help us. Thanks. ------_=_NextPart_001_01C3444D.39DAB170 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: offline replication [1499] </TITLE> </HEAD> <BODY> Yes, search in the Informix guides for Enterprise = Replication, that's what you needs ! (don't confuse it with High Data Replication) Yves -----Original Message----- From: nobody@ace.iiug.org [<A = HREF=3D"mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>]</FON= T> Sent: vrijdag 4 juli 2003 18:05 To: ids@iiug.org Subject: offline replication [1499] Hi. We're developing a database application for = administrative tasks and we need to replicate our main database thru a = few sites. The problem is that those sites won't be on-line and need to = insert/update regional data (it's not necessary that the new data are = available immediately). Does anybody knows a technique to do this painless? = We are thinking about an application solution (keeping track of new or = modified records to distribute on every site) but we think this is = problematic and maybe dangerous in some degree. I already read the "Administrator's Guide" = for any clue, but I didn't find anything similar. Our main server is a HP 9000 machine with HPUX 11.0 = and Informix 9.20D5. Every other site will work with a small server = (Intel) using Linux and a newer version of Informix. We're developing = on Windows. I hope that somebody can help us. Thanks. </BODY> </HTML> ------_=_NextPart_001_01C3444D.39DAB170--

↪ replying to Colin Bull

Fernando Garcia — Mon, 07 Jul 2003 06:24:25 — source: IIUG Forums & Mailing Lists

But Enterprise Replication can give us a 'transportable' copy (in tape or disk file) of the data needed to be updated rather than try to connect to any other server to make the updates by itself? That's our main problem: we can't have connected our servers (for geographical reasons); if Enterprise Replication can do the above, then I'll go for it.

↪ replying to Fernando Garcia

Madison Pruet — Mon, 07 Jul 2003 11:54:56 — source: IIUG Forums & Mailing Lists

If this is a requirement, then the only way that I know of to do this is to put insert/update/delete triggers on the table and put a copy of the row with it's operation and time (or serial column) into a staging table, unload the table, then apply on the targets. M.P. "Fernando Garcia" <chinconkuak@yaho To: ids@iiug.org o.com.mx> cc: Sent by: Subject: Re: RE: offline replication [1510] forum.subscriber@ iiug.org 07/07/2003 01:24 AM But Enterprise Replication can give us a 'transportable' copy (in tape or disk file) of the data needed to be updated rather than try to connect to any other server to make the updates by itself? That's our main problem: we can't have connected our servers (for geographical reasons); if Enterprise Replication can do the above, then I'll go for it.

offline replication

Related threads

Your privacy choices