Trigger Replication Settings

Create Replication wizard and Create Multiple Replications wizard Source Log Info Screen

The information in this topic applies to trigger-based replications supported for databases as described in Source and Target Options.

For transactional replications using triggers as a source, you need to identify the location and start point of transactions to replicate in the Create Replication wizard and Create Multiple Replications wizard Source Log Info screen.

Master Table Qualifier

The qualifier for the master table specified when setting up the connection to the database.

Master Table Name

The name of the master table specified when setting up the connection to the database.

Transaction ID

The ID for the transaction at which you want to start replication.  If you want to change the transaction ID, click Read... to open the Read Point dialog.

In the Transaction Read Point dialog, you can either retrieve the current transaction or the transaction for a specified date and time. If you enter a date and time, Syniti DR retrieves the first transaction after the time entered.  This information is available and can be changed in the Replication Properties dialog after the wizard is completed.

Transaction Timestamp

The timestamp for the transaction above.

Read Interval (sec)

The frequency (in seconds) with which you want to check the log during replication. For example, if the setting is 90 seconds, Syniti DR will check the log every 90 seconds to see if any transactions have occurred that need to be replicated to the target table. This information is available and can be changed in the Replication Properties dialog after the wizard is completed.