Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-03 : 08:46:32
|
| Sunil writes "I have one publisher and more than one subscribers. I want to synchronize data between them (for several tables) using SQL server merge replication. I am able to do that, but in case the same row of data is changed at both ends, I need the later changes to win. Currently SQL server applies the publisher's changes in such cases. I am trying to write my own SP for custom conflict resolution but where can I pick up the change time from? I can't find a datetime field in the transaction logs, and I can't add a datetime field in all my tables, it would be too much of an overhead to maintain it through my application. Hope someone can help, Thanks." |
|
|
ianyates
Starting Member
6 Posts |
Posted - 2003-02-24 : 02:14:30
|
| Hi - have you tried using Timestamp columns? I am about to work with replication myself, and in the research I've done you can tell SQL to use the timestamp type columns (which are auto-populated) to do the conflict resolution for you automatically. |
 |
|
|
|
|
|
Custom Conflict Resolver for Merge Replication