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.
| Author |
Topic |
|
hornet
Yak Posting Veteran
96 Posts |
 Posted - 2008-10-30 : 14:06:55
|
| Hi all!I've recently implemented merge replication where there is one publisher server and plenty of subscribers. All conflicts I ought to resolve by backoffice where man's going to resolve each point.So my question how and where to find all information about happened conflicts during replication.Also I'm interested either to update table only on publisher or on each subscribers?Thanks in advance! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-30 : 23:00:19
|
| You can use Conflict Viewer or sp_helpmergearticleconflicts to see conflicts and interactive resolver to solve conflicts.Also I'm interested either to update table only on publisher or on each subscribers?Do you mean when there is conflicts or Can you explain clearly? |
 |
|
|
hornet
Yak Posting Veteran
96 Posts |
Posted - 2008-10-31 : 15:05:12
|
quote:
Originally posted by sodeep
You can use Conflict Viewer or sp_helpmergearticleconflicts to see conflicts and interactive resolver to solve conflicts.Also I'm interested either to update table only on publisher or on each subscribers?Do you mean when there is conflicts or Can you explain clearly?
thanks but sp_helpmergearticleconflicts returns me articles which are involved in conflict, but I have to get and resolve conflicts data from backoffice manually. So I should to get the structure of conflicts data stroring. Now I found that for each object which involved in replication SqlServer creates conflictsTable but there are a lot of conflicts situations e.g. one server deleted a row but in the same time another updated it and what will be in this table and how to resolve this I'd like to ask |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-01 : 12:12:09
|
| Thats why you should use Interactive resolver to determine who gets priority on basis of DML statement |
|
|
|
hornet
Yak Posting Veteran
96 Posts |
Posted - 2008-11-01 : 13:54:46
|
quote:
Originally posted by sodeep
Thats why you should use Interactive resolver to determine who gets priority on basis of DML statement
because it can't be resolved only by sql scripts logic. There are a lot of situations when can be more than one possible ways to resolve. So doing this backoffice admin can resolve manually and it will be log in database. Don't u know how to implement what I said better? |
|
|
|
|
|
|
Resolving merge replication conflicts