hi all,
I am using merge replication with push subscription.i am getting conflicts
in some tables.i am not resolving any conflicts.so the system can resolve or
those conflicts can be cleaned.please suggest how to resolve conflicts.
with the help of rowguid can i retrive the entire record which came in
conflict
in which table it is available
please suggest information to review the conflicts
thanks
reddy
right click on your publication and select view conflicts. When the conflict
viewer comes up you can resolve the conflicts using the Keep Wining Change,
Show or Edit the conflicts, or Resolve with this data choices.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"reddy" <reddy@.discussions.microsoft.com> wrote in message
news:EC863DF6-3E55-4F62-8990-0825D579E710@.microsoft.com...
> hi all,
> I am using merge replication with push subscription.i am getting conflicts
> in some tables.i am not resolving any conflicts.so the system can resolve
or
> those conflicts can be cleaned.please suggest how to resolve conflicts.
> with the help of rowguid can i retrive the entire record which came in
> conflict
> in which table it is available
> please suggest information to review the conflicts
> thanks
> reddy
>
|||Hillary,
I am able to see the conflicts through the conflict viewer but Unable to
track all columns part of the conflict.my table structure
contains userid and createdate columns.if any user from publisher side or
subscriber side is trying to update the row then we will capture that userid
and date for reference.
Whenever a conflict occurs we are not able to view the userid
information part of the conflicts. This is required for us to identify the
source of the conflict
We want to rule out the following assumptions
a) conflict can occur within subscriber or publisher when an update happens .
In our merge replication process , conflict only occurs at update. NO
conflicts during inserts.
please help.now the database is in production i am unable to rectify this
problem.
awaiting for your response
your help is appreciated
regards
reddy
"Hilary Cotter" wrote:
> right click on your publication and select view conflicts. When the conflict
> viewer comes up you can resolve the conflicts using the Keep Wining Change,
> Show or Edit the conflicts, or Resolve with this data choices.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "reddy" <reddy@.discussions.microsoft.com> wrote in message
> news:EC863DF6-3E55-4F62-8990-0825D579E710@.microsoft.com...
> or
>
>
Friday, March 9, 2012
question about conflicts
Labels:
conflicts,
conflictsin,
database,
merge,
microsoft,
mysql,
oracle,
push,
replication,
resolving,
server,
sql,
subscription,
system,
tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment