MS SQLCE - Conflicts during replication

Author

Conflicts during replication

robert

2005-06-16, 8:24 pm

Hello,

I read in articles that there can occur two kinds of conflicts during
replication and that the SQL Server Reconciler solve such conflicts:

1) If more subscriber try to modify a row on the publisher database at the
same time.

2) If a certain row is modified at the subsriber database as well as the
coresponding row at the publisher database. So any one of those two have to
win and the other win will accept the changes of the other side.

So how does it look like when the Reconciler solve these two conflicts. How
does it work?

thx

rob

Darren Shaffer

2005-06-22, 1:23 pm

go to MSDN and search for "merge replication conflicts" - you
will get a number of papers that explain how the reconciler works
and how to customize it's behavior.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"robert" <robert@discussions.microsoft.com> wrote in message
news:9E578D7D-DA06-441F-8DAB- 414E2D37E393@microso
ft.com...
> Hello,
>
> I read in articles that there can occur two kinds of conflicts during
> replication and that the SQL Server Reconciler solve such conflicts:
>
> 1) If more subscriber try to modify a row on the publisher database at the
> same time.
>
> 2) If a certain row is modified at the subsriber database as well as the
> coresponding row at the publisher database. So any one of those two have
> to
> win and the other win will accept the changes of the other side.
>
> So how does it look like when the Reconciler solve these two conflicts.
> How
> does it work?
>
> thx
>
> rob

Sponsored Links