Search code examples
sql-server-2012merge-replication

Does it matter if time goes out of sync on merge replication clients?

I'm quite new on merge replication, but a scenario. If I have a server, and two clients with pull subscriptions does it matter if the time on those machines goes out of sync with each other or the server?

When I modify some data on one of those clients does it store the time against that change?

I am using MS SQL 2012.

I will be using a setup as described here,

http://msdn.microsoft.com/en-us/library/ms151329(v=sql.105).aspx

Solution

  • OK, I've found that merge replication doesn't store the time against a specific change.

    If you have client subscriptions then the first person to sync will win in the case of a conflict.

    If you have server subscriptions then the priority of those server subscriptions will determine who will win.

    Neither of these options rely on time.