kereni
16th August 2004, 14:46
Hi All,
I want to create replication server to our Informix installation.
Is there any guide for setup this kind of replication?
Thank.
triton45
17th August 2004, 22:00
Be more specific.
You want to replicate data from <insert rdbms product name> to <insert rdbms product name>
kereni
18th August 2004, 08:49
The rdbms is Informix 7.31 TD5 on Windows 2000
I want to setup replication between ol_prod to ol_repl
Thanks.
triton45
18th August 2004, 23:39
There are 2 kinds of replication available in Informix
"HDR is High Availability Replication. ER is Enterprise Replication. HDR is
'all-or-nothing' replication. ER is logical replication accross multiple
servers.
With HDR, there is one primary server and one secondary. The overhead is a
bit less than with ER because HDR has considerably less functionality.
However, HDR is designed for high availability and is very good at doing
that." <taken from http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=objga.221197%24L1.41440%40sccrnsc02>
We use ER to replicate only select tables from one database server to another. This works very well for us.
You can find the manuals for IDS 7.31 here
http://www-306.ibm.com/software/data/informix/pubs/library/ids_73.html
I would be glad to answer more questions about ER. Unfortunately, I don't know HDR.
Andy
kereni
19th August 2004, 09:23
Thank you very much for your help.