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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Conflict resolution

Author  Topic 

IB
Starting Member

4 Posts

Posted - 2007-06-15 : 03:03:30
Hello,

I use MSSQL 2000 server and publication to move data between SQL server and SQL CE 2.0 on a Window CE.Net device. I don't have any problem between these two.

My problem is when a CE.Net device has pulled from the publication and another source (like a web app) has updated the same record. When the CE.Net updates the same record and later pushes to the publication, this will create a conflict and the CE.Net would lose since its update was done a a later time.

Is there a way such that any update from the CE.net device always overides any updates prior and automatically resolve any conflict.

Thank you.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-15 : 15:15:35
Possible in merger replication.
Go to Top of Page
   

- Advertisement -