Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / February 2007

Tip: Looking for answers? Try searching our database.

Conflict resolution for Transactional Replication with Updating Subscribers

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ricisbest@yahoo.co.uk - 23 Feb 2007 08:22 GMT
Hi.

I'm trying to establish whether Transactional Replication with
Updating Subscribers meets my requirements.  I have chosen to use
"publisher wins" for the conflict resolution. (I'm using SqlServer
2005 Developer Edition on Win XP SP2 on both machines)

When I cause a conflict to occur by making an update to rows with the
same PK on both servers, the publisher indicates that there has been a
conflict, and that it chose the publisher as the winner.  However, the
losing transaction on the subscriber does not seem to be rolled back
like this article says it should: http://msdn2.microsoft.com/en-us/library/ms151177.aspx.
I'm then left in the state where the two tables are out of sync.

Any ideas anyone?
Cheers!
Rich - 23 Feb 2007 13:20 GMT
Some extra info...

I forgot to mention earlier that I'm using a push subscription.

I've found that if I choose 'subscriber-wins' instead, then it seems
to work OK, but unfortunately this is not what I require.

'Normal' changes to data on both servers are correctly replicated to
the other server. It's just publisher-wins conflict resolution that
doesn't seem to work.  The conflict is detected, but the publisher's
data is not applied to the subscriber (i.e. the subscriber change is
not rolled back)..  Any further changes to that row fail to go through
following the conflict.

Any comments appreciated,
Rich.

On 23 Feb, 08:22, ricisb...@yahoo.co.uk wrote:
> Hi.
>
[quoted text clipped - 12 lines]
> Any ideas anyone?
> Cheers!
Rich - 26 Feb 2007 07:46 GMT
Please can anyone give me some pointers here - I'm pulling my hair out
over this one!?

What would cause conflict resolution to work 'one way' (i.e. sub wins)
but not the other (i.e. pub wins)?  Updates via both the publisher and
the subscrubers both work fine, so it's not like MSDTC is not set up
properly.

Many thanks, Rich.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.