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 |