Merge Replication custom conflic resolution

[Lonifasiko]

Hi all,

I'm bound to start using Merge Replication technique to synchronize
data between SQL Server CE 2.0 and SQL Server 2000.

However, it seems horrible to me the default option of "server always
wins" in case os conflicts during synchronization. I want to change
this by-default option. A better approach in my case would be "last
writer wins", that is, see somehow the date in which each record was
last modified and write this data to the server.

Is it possible to do that easily with Merge Replication? Can I query
the conflict resolution table on server and consequently modify the
server's "by-default" option of server always winning? I've read
something about execute a stored procedure when conflict is detected
etc., but don't know if it works.

I know that RDA uses the approach of "last writer wins" but I think
it's far more complicated that Merge Replication, don't you?

Can anybody give me serious information around this issue? It's very
important and urgent and any advice will be greatly appreciated. Thanks
very much.

 

[Darren Shaffer]

you have an incorrect understanding of the current conflict resolver
in merge replication. go to MSDN and search for How Merge Replication
Works.

writing custom resolvers is a highly non-trivial exercise.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com