Replicator (E) is built upon Replicator (OS) source code. It offers following major advantages over Replicator (OS)
- Have minimum overhead on database performance, as it add few triggers on every table and create single table for recording changes to records. On the other hand, Replicator (OS) create multiple tables for recording changes
- Replicator (E) is faster, it supports realtime data integration, time lag for integrating for one lakh record on simple Pentium-4 machine in mysql is-'please fill in the figure', on the other replication(OS) takes 'this much time' in replication
- Replication (E) is more robust, has simpler and stronger architecture and therefore can handle very heavy workloads and is suitable for mission critical application.
- Replicator (E) is much simpler to use. Configure datasource, create job, schedule or synchronize, done.
- Replcator (E) is works on webservices and ftp and suitable for working over internet. Replicator (OS) works on RMI.
- Replciator (E) supports working directly on datasource in LAN, without need of installing replicator client. Replicator (OS) always needs a Replicator Client.