Re: Question on data base replication
In article <446qso$3o5@cssun.mathcs.emory.edu>, CRAIG@CHEMISTRY.CHEM.UTAH.EDU wrote: > Terence, > > I'm sorry to say that Informix's "data replication" feature isn't > what you're looking for. First, it only works with two databases; a > primary and a secondary. Second, the secondary database cannot be > updated by anyone except the DR process. It's essentially a read > only database. > > I'm sorry to report this because I have a situations much like > yours. At my site, I'm handling the replication manually much as > you describe (using triggers and custom application code). Ugly, > obscure and slow, to say the least. I'd love to know how others have > handled this! I believe there are some third-party products which > support this, but I don't know who they are or if they've been released yet. > > --Craig (craig@chemistry.utah.edu) Hello Craig, One of the replication tools you may want to look at is OmniReplicator from Praxis. It is a heterogeneous replicator (so between all kinds of databases on all kinds of platforms), and has all kinds of features relating to industry-strength replication. They have a web site at http://www.praxisint.com/ where you may find more. Kind regards, --------------------------------------------------------------------- Michiel Carpentier | Tel: +32-15-30 77 00 TechGnosis International | Fax: +32-15-32 12 60 A. Stocletlaan 87 | ------------------------------------------ B-2570 Duffel | mcarpentier@techgnosis.com BELGIUM (*We've moved!*) | http://www.techgnosis.com/techgnosis/ --------------------------------------------------------------------- ----- SequeLink, the freedom of choice Client/Server MiddleWare ----- ---------------------------------------------------------------------