Sunday, July 11, 2021

Data Replication LS Retail Series Part 4:- What are replication Counters?


Replication Counters


Replication counters are nothing but a Integer field which acts like a counter to track till which record replication has been completed. 

What does LS Retail says about Replication counter?

This field contains the number of the field that is used as a replication counter for the From-Table ID in the replication process.

The Replication Counter allows the replication process to recognize the records that have been inserted or updated in the database being replicated from since the last replication took place to the same location, and replicate these records only.

When the Replication Method of the data exchange is Normal, the Replication Counter is a number of a field in the From Table that is given a value when a record in the table is inserted or modified. The value is a number one higher than the Replication Counter number that was given to the last record inserted or modified in the table. With this method, it is not possible to keep track of records that have been deleted.

If you want to replicate only records that have been inserted or modified, you need to select the by Normal Replication Method and add a Replication Counter field to the table. The field must be of type number (integer) for the replication to function.


Replication Counter in the Transaction Header (99001472)


*Replication counter increases by one after record is inserted on the Transaction Table

In the Schedular Job Card the Last replication counter table wise is maintained







No comments:

Post a Comment