728x90
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 |
http://www.inturi.net/coranto/viewnews.cgi?id=EkpuAFpkkyOKeKEaaY
728x90
'Informix > informix reference' 카테고리의 다른 글
The archecker Schema Reference (0) | 2011.08.31 |
---|---|
Informix Pocket Guide (0) | 2011.07.15 |
Salvaging Logical-log files using ontape (0) | 2011.04.28 |
11.70 : 통계 정보 관련 (fragmnet-level 및 자동 통계 갱신) (0) | 2011.04.28 |
IDS 11.7 Floating User 라이센스에 대한 설명 (0) | 2011.04.17 |