dbTalk Databases Forums  

Laptop subscription conflicts

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication


Discuss Laptop subscription conflicts in the microsoft.public.sqlserver.replication forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David
 
Posts: n/a

Default Laptop subscription conflicts - 01-26-2006 , 04:46 PM






We are having some data conflicts with some laptops that have "timed out"
and not finishing a synch. Once they are successful, will these conflicts
resolve themselves? For example one of the conflicts is due to a FK/PK
problem because (I think) that one of the tables did not get synched and the
failing one had records in it that related to that table. Is this possible?
Thanks.

David



Reply With Quote
  #2  
Old   
Hilary Cotter
 
Posts: n/a

Default Re: Laptop subscription conflicts - 01-26-2006 , 08:12 PM






Conflicts are always resolved. The winning row gets entered in the database,
the loosing row gets entered in the conflict tables.

The are always resolved - but perhaps not in the way you like Normally the
next time the agent will run the missing rows should be carried over. Note
that you will have to put the Not For Replication clause on all constraints
for this to happen.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"David" <dlchase (AT) lifetimeinc (DOT) com> wrote

Quote:
We are having some data conflicts with some laptops that have "timed out"
and not finishing a synch. Once they are successful, will these conflicts
resolve themselves? For example one of the conflicts is due to a FK/PK
problem because (I think) that one of the tables did not get synched and
the failing one had records in it that related to that table. Is this
possible? Thanks.

David




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.