locked
Does a Push Subscription effect other Pull Subscriptions?? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have a publication which is subscribed at 5 places and all are pull subscriptions now i have to add a new subscription and due to limitation of SQL Server 2008 R2 Web Edition i need to create a Push Subscription, so i am concerned how this Push Subscription effect on others Pull Subscription, is there any issue in this if i create a push subscription and what effect will come on my already created pull subscription?

    Thanks in Advance


    Thursday, April 21, 2011 6:17 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote
    Your other subscriptions should be fine.  I was able to create a new push subscription in my test environment and synchronize both push and pull subscribers just fine afterward.
    • Proposed as answer by WeiLin Qiao Tuesday, April 26, 2011 6:11 AM
    • Marked as answer by WeiLin Qiao Sunday, May 1, 2011 12:48 PM
    Thursday, April 21, 2011 7:24 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    You won't be able to change your existing subscriptions from pull to push but you should have no problems creating new push subscriptions.

    Hope this helps.

    Thursday, April 21, 2011 7:01 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks for reply no i don't want to change my existing Pull subscriptions , i just want to know if a new Push Subscription will make create any issues or change any other subscriptions in my environment.
    Thursday, April 21, 2011 7:06 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Your other subscriptions should be fine.  I was able to create a new push subscription in my test environment and synchronize both push and pull subscribers just fine afterward.
    • Proposed as answer by WeiLin Qiao Tuesday, April 26, 2011 6:11 AM
    • Marked as answer by WeiLin Qiao Sunday, May 1, 2011 12:48 PM
    Thursday, April 21, 2011 7:24 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    There will be no effect, each subscription is independent of each other.
    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Thursday, April 21, 2011 12:40 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Technically , there will be no problem ....But Since it will be a push subscription there will be an addiional overhead on Distributor ( which is not in the case of pull subscription ) .This might cause latency in case your distributor is already loaded .I would suggest deply this in test\staging first and see in case the Distributor latency increases to unacceptable level ..if not then you are fine to go ...

     

    Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/
    Saturday, April 23, 2011 9:40 AM