I'm new in synchronization work. I am confused that:
If I synced 10 rows first time, then add 10 more rows and sync them again, then Sync framework will sync the whole 20 rows again??
And if it syncs only newly added 10 rows, then how does it come to know about new rows and already synced rows??
I searched it, but could not get any relevant answer. Anyone please explain it. Thanks in advance!!!
sync fx will only sync incremental changes or changes that occurred after the last sync.
in your first scenario, its should only sync the 10 new rows on next sync.
the second scenario is the actual behavior.
Sync fx does change tracking to keep track of changes that occurs to the table being synched (insert/update/delete). it also records an anchor/marker when it last synched so it knows it should only be retrieving changes that are later than that anchor/marker.