Replication Types

Syniti Data Replication allows you to replicate data between database tables in the following ways:

• Refresh
  A one time complete replication from source to target table, according to replication settings and scripts. You can control the timing of the replication, identify the columns to be replicated and add scripts to transform data during replication. The source and target databases can be on the same or different database servers and platforms. For example, you can replicate a Db2 table to an Oracle database or a SQL Server table to IBM Db2 for i (iSeries/AS400).
  Note that when performing a refresh replication, Syniti DR deletes all target records before inserting records from the source table. To avoid truncation of all records from the target table, you can write a script for the Refresh_onBeforeTruncate event.
  Steps for Replicating a Table Using Refresh Mode

• Continuous refresh
  A regularly scheduled refresh replication as described above. The schedule is defined in the replication settings.
  Steps for Replicating a Table Using Refresh Mode

• One-way mirroring
  A continuous update of a replicated table based on changes to the source database that have been recorded in the database server log. Typically, this involves an initial refresh operation, as described above, to set up the target table. Then you can define the replication settings to check the transaction log on the source database at regular intervals. Any changes found in the log would be applied to the target database.
  Steps for Replicating with One-Way Mirroring

• Synchronization or two-way mirroring
  Syncronization is appropriate when changes occur in both tables involved in the replication. Your replication settings ensure that both tables maintain the same state by checking the logs on each table and performing updates on each table as needed.
  Steps for Replicating with Synchronization