Replication Tool for Informix ?
Posted in 1997
Hey folks, I need some information about existing tools or conceptional solutions for asynchronous replication of (parts of) Databases under Informix Online 7.10. Information about solutions on other RDBMSs (Oracle, DB2, Sybase, SQLServer etc.) is also very welcome! I've heard about the Informix Enterprise Replication, a tool that is part of the new Online Server 7.22. But this Version isn't available for Unixware 2.x / Intel Pentium, the platform I'm using. I'm especially interested in asynchronous replication in loosely coupled networks where multiple sites have equal ability to update the data. That means a user on host A could update a record that is replicated on host B and changed there at the same time. What I need is a tool / solution that automatically does the data exchange needed for replication and recognizes possible collisions /conflicts resulting from multiple updates on the same (replicated) records. There could be several possibilities to handle those conflicts: 1) the data of one host has priority to other hosts 2) the update is cancelled for colliding records and remarked in a log file 3) the conflict is resolved with user - defined methods 4) ... ? If you know of any conceptional - or software solutions for my problem please contact me via email or with a reply in this newsgroup. Thank you, Holger. :-) ------------------------------------------- Holger Weidemann ISR Software Consulting GmbH Hagenbruecke 1/2 38100 Braunschweig email: ho.weidemann@tu-bs.de -------------------------------------------