Post reply

Creating a Pull Subscription

  • October 5, 2005 at 3:05 pm

    #595275

    I think you get the data since the subscriber was created.  Set up a little test replication of a small table & try it out.

  • October 5, 2005 at 3:08 pm

    #595277

    Thanks for the info.  I did get it working using the full snap shot.  You have to make sure you have the bulkinsert flag on in the distributor.

  • October 6, 2005 at 1:29 am

    #595345

    You should only use the data and schema exists option if the data is already synch'd at both ends..if you make a change to a record at one end it does not exist at the other end you'll get problems.

    A full snapshot is the correct way to go..but on a large database can take a lot of time, especially over a limited connection.

    You could always use backup and restore to get the data to the second server and then use data and schema exists.

    HTH Graeme

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

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