Re: mixing merge replication with RDA

no, not necessarily in separate databases, but make sure any tables
or subsets of tables you are going to RDA pull with tracking on have
no overlap with articles you publish for merge replication.

when you add a table to a merge publication, that table
receives 3 GUIDs to track added, removed, and modified rows.
when you pull a table with RDA and tracking on, a single
GUID is added to the table to track changes. you can (and
likely will) create situations where the reconciler on the server gets
confused if a single table is involved in both RDA and Merge.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Rob Blij" <robblij@xxxxxxxxxxxxxxxx> wrote in message
news:OziJqBTgFHA.2916@xxxxxxxxxxxxxxxxxxxxxxx
> When you say separated, are you saying in different databases?
>
> If so what is your reasoning?
>
> tnx
> Rob
>
>
> "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:OZWUxiRgFHA.132@xxxxxxxxxxxxxxxxxxxxxxx
>> Rob,
>>
>> I have used this approach in the past and it makes great sense
>> in certain situations. My advice: keep your RDA-pulled tables
>> and your merge publication articles separated.
>>
>> --
>> Darren Shaffer
>> .NET Compact Framework MVP
>> Principal Architect
>> Connected Innovation
>> www.connectedinnovation.com
>>
>>
>> "Rob Blij" <robblij@xxxxxxxxxxxxxxxx> wrote in message
>> news:%23qF2J1LgFHA.272@xxxxxxxxxxxxxxxxxxxxxxx
>>> Has anyone had any issues or know of any problems with using merge
>>> replication and RDA in the same sql server db?
>>>
>>> I have managed to implement this and all tests seem fine but would like
>>> some info from anyone who has used this approach before.
>>>
>>> Tia
>>> Rob
>>>
>>
>>
>
>


.

Relevant Pages

  • Speeding up the RDA Push and Pull
    ... RDA Pull and Push to sync the data between the PPC and the Central Server.We ...
    (microsoft.public.sqlserver.ce)
  • RE: Pull() gives 28037 error over Internet
    ... We are not using GPRS, ... We are using tracking. ... it works through firewall as well. ... > Does it ever fail to sink the data via RDA when the PocketPC is in the cradle? ...
    (microsoft.public.sqlserver.ce)
  • Re: After RDA Pull, first insert/update to db crashes app
    ... "Darren Shaffer" wrote: ... rda = new SqlCeRemoteDataAccess; ... remoteConnectionString); ... After a RDA Pull, I am having a problem where my application crashes on ...
    (microsoft.public.sqlserver.ce)
  • Re: After RDA Pull, first insert/update to db crashes app
    ... rda = new SqlCeRemoteDataAccess; ... UpdateProgress(bar, 25, status, "Loading Company ... remoteConnectionString); ... After a RDA Pull, I am having a problem where my application crashes on ...
    (microsoft.public.sqlserver.ce)
  • Re: Identity insert, custom sync process
    ... In order to get rid of the identity on a field when performing RDA with ... > with no tracking, no indexes, however it seems that the ... > readonly/identity property still comes down via RDA. ... > property from a column that was initially identity on the server. ...
    (microsoft.public.sqlserver.ce)