Daffodil Replicator is a Java tool for data synchronization, data migration, and data backup between various database servers. Daffodil Replicator works over standard JDBC driver and supports replication across heterogeneous databases. At present, it supports following databases: Microsoft SQL Server, Oracle, Daffodil DB, DB2, Derby, MySql, and PostGreSql. Daffodil Replicator is available in both enterprise and open source versions referred as Daffodil Replicator(E) and Daffodil Replicator(OS) respectively. For more details on Daffodil Replicator (E) or Daffodil Replicator (OS), click on the links on the left.
Features of Daffodil Replicator
Daffodil Replicator provides various features to replicate data between different databases. Various features are:
- Bi-directional Data Synchronization ??? Daffodil Replicator supports bi-directional data synchronization. It allows you to synchronize all the datasources available in the replication process. It maintains data integrity by applying all the changes made at one end to another end and vice versa in the replication process.
- Supports replication across heterogeneous database ??? Daffodil Replicator supports replication among different databases. For example, you can use one datasource as Daffodil DB and another as SQL Server in the same replication process.
- Conflict detector and resolution ??? Daffodil Replicator provides conflict detection and resolution functionalities that allow you to make changes in the same database simultaneously. For example, A conflict occurs when the changes are made in the same record of a database simultaneously from different locations. In case of conflicts, Daffodil Replicator automatically manages consistency based on the settings specified by the user at the time of creating job or subscription.
- Partial Replication ???Daffodil Replicator also allows you to replicate only a part of the database in place of replicating the whole database. For example, you can replicate some tables from a database by selecting the table names. In addition, you can replicate some rows and columns from a database using filtering.
- Large datatype support Replicator supports almost all data types of supported databases. It also supports BLOB and CLOB replication.
Daffodil Replicator (E) Vs Daffodil Replicator (OS)
- Daffodil Replication (E) is more robust and has simplex architecture.
- Daffodil Replicator (E) creates a single table for recording changes to the database records, whereas Daffodil Replicator (OS) creates multiple tables for recording these changes. Therefore, Daffodil Replicator (E) reduces the overhead on database performance
- Daffodil Replicator (E) is faster and supports real-time data integration.
- Daffodil Replicator (E) can replicate data over Internet.
- Daffodil Replicator (E) uses web services as compared to RMI in case of Daffodil Replicator (OS).
- Daffodil Replicator (E) can perform replication among various datasources in a LAN directly without installing Replication DataSource, whereas with Daffodil Replicator (OS) we need to install a Replication Client.