Post reply

Can snapshot be sort-of avoided in merge replication?

  • June 18, 2007 at 3:57 pm

    #103378

    Guys,

    I am considering to set up a merge replication.  The issue is that the tables I plan to replicate are too big (~50GB) in total.  I think that snapshot agent will take forever to copy them over to the subscriber.

    Is there a way to avoid this [i.e. maybe restore the database at the subscriber] and then somehow make the necessary tables part of the merge replication.

    Please advise

    Thanks a lot

  • June 19, 2007 at 11:19 pm

    #714005

    Yes.

    You can avoid, by restoring a copy of the database at the subscriber. while setting up snapshop there is an option which will prompt to do this.

    HTH

    rangark

     

     

  • June 20, 2007 at 7:48 am

    #714104

    I'll try that.

     

    Thanks a lot!

  • June 21, 2007 at 5:19 am

    #714304

    Hi,

    You certainly can do that. When you apply replication (tran or Merge) you have the option to perform a no-sync subscription. In other words the subscriber is already in sync with the publisher.

    We have similar issues...one way we have used is to BCP the data to text files and compress and copy those to the subscriber. This saves a little effort in having to totally restore.

    Regards

    Graeme

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

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