Two-way database replication

1. This job will update/add rows in the secondary database table from the primary database table. Tables can reside in the same or different databases managed by different database systems (e.g Oracle to Oracle or SQL Server to Oracle, and so on). Source and target table must have same number of columns and columns must have compatible datatypes. The job will preserve rows in the secondary table that don't exist in the primary table.
2. After "primary to secondary" table replication, the job will add data to the primary table from the secondary table for rows that exist only in the secondary table, but not in the primary table

Download this template