Comparison between Informix Enterprise Replication(ER/CDR) and MACH 11(HDR, SDS and RSS) -- Posted by inturi on Friday, March 7 2008

Informix Enterprise Replication(CDR) Informix MACH11 (HDR, SDS and RSS)
Replication granularity is at table and column level Replication granularity is at the instance level
Supports hierarchical routing. (Supports root, non-root and leaf servers). All secondary servers has to be directly connected to primary server
Supports update anywhere, data consolidation and data dissimination models Secondary servers are read-only servers and can be used only for reporting activity
Supports hetorogenious replication. i.e ER can replicate data between 11.10 and 7.31 servers Primary and secondary server version has to be same
ER servers doesn't have to be running on the same operating system platform Hardware platform has to be same between primary and all secondary servers
ER needs primary key for all the replicated tables Doesn't need primary key for replication
Can co-exist in MACH11 environment Can co-exist with ER
Database must be logging database Database must be logging database
Supports blob space blobs along with smartblobs and partition blobs Doesn't support blobspace blobs. Supports smartblobs and partition blobs
Source and target must use the same code set for replicated tables Database codeset must be same between primary and secondary servers
Supports network encryption Supports network encryption
Supports compression before transmitting data through network Doesn't support data compression

[Edit] Home
If this information is helpful to you then please click here and post one simple tip that you know. Share your knowledge!