dbTalk Databases Forums  

RE: replication --general question

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


Discuss RE: replication --general question in the microsoft.public.sqlserver.replication forum.



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

Default RE: replication --general question - 11-18-2004 , 01:08 PM






Optimistic concurrency is more an application feature than a replication
feature.

Replication addresses the issue of conflicts in the data. There are
automatic conflict handlers and you can set priorities so that an update in
one location will get preference over the same update elsewhere.

Decide on which replication model you need (transactional, merge), then you
can see how your data will behave in that model.



"Kina" wrote:

Quote:
Hello,

I am new to replication. And my boss has asked me to investigate the
following.
For handling optimistic concurrency which approach should we use...
like should we add a timestamp column or should we check the values of all
the columns.
If we add timestamp column will it have any affect while replicating.(i dont
have a clue!!)
If we decide to check the values of all the columns then it might take long
time for updations.

please help!!
-Kina


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.