Post reply

Replication Pull subscription from SQL Express

  • July 26, 2011 at 1:36 am

    #390048

    Hi all,

    I have to use Snapshot replication to around 20 SQL Express clients across out network.

    I was hoping to use PULL Subscriptions on the clients but don't know if you need the SQL Agent to run a Pull? Or if its not possible for another reason?

    Does anyone have any dealings with using SQL Express and Replication? and care to share some overview..

    Thanks

    S

  • July 26, 2011 at 9:30 am

    #1358611

    As far as I know, SQL Server Express functions only as a Subscriber.

    -Roy

  • July 26, 2011 at 9:33 am

    #1358614

    Hi thanks for the reply..

    But is possible to use Pull subscriptions on express? via a script..

    then create a quick button to run the script and joy!

    cheers

    s

  • July 26, 2011 at 9:45 am

    #1358629

    I have heard of of people using some hacks to get it to work. But I have never tried it. You might have to use RMO and Windows synchronization method to get it work.

    -Roy

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

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