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.