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 2005 Forums
 Replication (2005)
 Replication without conflict checking

Author  Topic 

mharlan
Starting Member

4 Posts

Posted - 2007-05-30 : 12:56:14
Hi all,

Is there a way to replicate all data in a table but on certain columns avoid throwing a conflict? I have serveral SQL servers running Tx-Rep and almost all of the tables contain a DateModified field. I don't really need to check for conflicts on this data but want to keep it in tact as much as possible.

Any Ideas?

Thanks in advance,
Michael

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-30 : 16:35:19
Which replication do you use?
Go to Top of Page

mharlan
Starting Member

4 Posts

Posted - 2007-05-30 : 16:43:33
Sorry... We use Merge.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-30 : 17:32:59
Don't think you can disable conflict checking, but you can define your own role.
Go to Top of Page

mharlan
Starting Member

4 Posts

Posted - 2007-05-30 : 17:53:11
What do you mean my own role? Is this akin to writing a custom resolver for the conflict checking?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-30 : 23:08:44
Not necessary, there are options you can choose from.
Go to Top of Page
   

- Advertisement -