Comparison between Informix Enterprise Replication(ER/CDR) and MACH 11(HDR, SDS and RSS)

@ipajama 2011. 6. 23. 22:33

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