Merge Replication Updates during Initialize

  • I have a merge replication scenario where the technicians are filtered by their individual codes. Each technician has his own mobile device for collecting and synchronising data.

    On initialisation of the subscription, the user should only get the data that is relevant to their code.

    The client is staging the rollout to all of their technicians and as the system has grown, we have noticed that there are a number (getting larger every day) of updates that are creeping into the initialisation of each subscription.

    My understanding is that an initialisation will only ever apply the inserts necessary to create the subscriber database.

    Is my understadning incorrect?

    Is the some parameter in the creation of the publication that we have set incorrectly?

    Is there something wrong with SQLServer 2005 itself?

    I am very interested to hear anyones comments or advice around this issue.


    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

  • This was removed by the editor as SPAM

  • As per my other post regarding the differences between replication in 2005 and 2000, this is a known issue with a simple resolution

    http://support.microsoft.com/kb/917476/en-us


    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply