Daffodil Replicator (E) is a Java tool for data synchronization, data integration, data migration, and data backup between 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, PostGreSql, Firebird.

Features

• Bi-directional Data Synchronization ?? Daffodil Replicator supports bi-directional data synchronization. It allows you to synchronize all the datasources used in the replication process. It maintains data integrity by updating 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 database as Daffodil DB and another as SQL Server in the same replication process.
• Supports unlocking ?? Daffodil Replicator does not set any lock while retrieving and merging changes to the database.
• Security ?? Daffodil Replicator enables you to replicate data in a secure environment using HTTPS (HTTP over SSL). To know more about security, please click here.
• Conflict detection and resolution ?? Daffodil Replicator provides conflict detection and resolution functionalities that allow you to make changes in the same table stored at different locations. For example, Lets assume emp table is stored at Database A and Database B. An employee (named as James) address is changed. It is updated in Database A but not in Database B. Therefore, a conflict occurs between the emp table stored at Database A and Database B. In such a case of conflicts, Daffodil Replicator automatically manages consistency between the data 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 selecting the table names. In addition, you can replicate some rows and columns from a database using filtering.