Update Replication Counter, Scheduler Subjob

This field contains a check mark if the replication process should update the Replication Counter field in the table replicated to in the destination database. The Replication Counter field in the destination table is then incremented by one.

The table replicated to must have the Replication Counter field as a key.

Example A replication counter field has been added to the Customer table. A scheduler subjob has been set up to replicate changes in the Customer table from the stores to head office. In order to have changes in the table replicated from store to head office and then again to the other stores, a checkmark is placed in the Update Replication Counter field for the subjob. Then the replication counter in the head office will be incremented by one with regards to the highest replication counter number in the head office. To finish the setup of subjobs for replicating the Customer table, another subjob is set up that replicates from head office to the stores the changes made to the Customer table in the head office and changes that have been replicated from the stores to head office. This subjob replicates by using the same Replication Counter field as the job from the stores to head office.