Replicate1 / DataMirror / etc - Trigger or Log Replication
tomcaml asked for software besides Replicate1 or DataMirror to move Informix data in real time. Keith Simmons suggested HDR for everything, ER for subsets, and EGM for other DBMSs, and asked for platform details. In reply to Tom's question, scottishpoet described the Informix Enterprise Gateway Manager. Captain Pedantic made a sarcastic remark about ER's reliability.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello Does anyone know of software that will move data in real time, either based on triggers or reading the Informix Log, besides Replicate1 or IBM's DataMirror (which apparently does not even work with Informix). Thank you
On 24/10/2007, tomcaml@yahoo.com <tomcaml@yahoo.com> wrote: > Hello > > Does anyone know of software that will move data in real time, either > based on triggers or reading the Informix Log, besides Replicate1 or > IBM's DataMirror (which apparently does not even work with Informix). > > Thank you > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Do you want to move all your data? in which case HDR could fit the bill. Do you want to move a subset, either of tables, columns or rows? In which case ER is your friend. Are you moving the data to another IDS instance/database or to a.n.other DBMS? in which case you may want to look at EGM. Platform, O/S, IDS Version, who, what, where, when, why? More questions than answers !!! Keith
On Oct 24, 7:38 am, "Keith Simmons" <smile...@googlemail.com> wrote: > On 24/10/2007, tomc...@yahoo.com <tomc...@yahoo.com> wrote:> Hello > > > Does anyone know of software that will move data in real time, either > > based on triggers or reading the Informix Log, besides Replicate1 or > > IBM's DataMirror (which apparently does not even work with Informix). > > > Thank you > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > > Do you want to move all your data? in which case HDR could fit the > bill. Do you want to move a subset, either of tables, columns or rows? > In which case ER is your friend. Are you moving the data to another > IDS instance/database or to a.n.other DBMS? in which case you may want > to look at EGM. > Platform, O/S, IDS Version, who, what, where, when, why? > More questions than answers !!! > > Keith Keith, What is EGM? Tom
"Keith Simmons" <smiley73@googlemail.com> wrote in message news:mailman.282.1193229499.26742.informix-list@iiug.org... > On 24/10/2007, tomcaml@yahoo.com <tomcaml@yahoo.com> wrote: >> Hello >> >> Does anyone know of software that will move data in real time, either >> based on triggers or reading the Informix Log, besides Replicate1 or >> IBM's DataMirror (which apparently does not even work with Informix). >> >> Thank you >> >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list >> > ... Do you want to move a subset, either of tables, columns or rows? > In which case ER is your friend. Er, albeit a fairly unreliable friend who's likely not to be around when you really need his help.
http://www-306.ibm.com/software/data/informix/tools/egm/ Informix Enterprise Gateway Manager Overview Informix Enterprise Gateway Manager is an SQL-based gateway that allows a customer's Informix tools, applications, and databases to interoperate transparently with non-Informix databases. Makes the underlying target DBMS appear to both client and server applications as an instance of Informix Dynamic Server Distributed joins with Informix, Oracle, and Sybase data in a single SQL statement Security for only authorized users Unrestricted connection support Scrolling cursor support System Requirements Informix Enterprise Gateway Manager runs on AIX, HP-UX, Solaris, Windows' NT', and Windows XP'.