Post reply

Need information about Pish and pull subscription

  • December 20, 2012 at 10:19 pm

    #271848

    Hi All,

    Here I am new to the Replication.

    So i want to know what is the push and pull subscriptions and how it will work.

    When it will use.

    Also please suggest some referral books and links about this topic.

    Thanks in advance.

  • December 20, 2012 at 10:31 pm

    #1570717

    SORRY Push and pull

  • December 21, 2012 at 4:57 am

    #1570844

    gantavasu (12/20/2012)

    Hi All,

    Here I am new to the Replication.

    So i want to know what is the push and pull subscriptions and how it will work.

    When it will use.

    Also please suggest some referral books and links about this topic.

    Thanks in advance.

    I am assuming you mean Transactional Replication which is the most common type implemented. Typically you would implement a push subscription by default. This means that when new data is applied to the database published for replication, i.e. the Publisher, it is automatically transmitted to a Distributor where it is then applied to all Subscriber databases. You would use this if you wanted Subscribers to stay as close to in-sync wth the Publisher as possible. This might be a relevant scenario when wanting to setup a refer-only copy of a database for reporting or to supply the same data to multiple or distributed applications.

    A pull subscription is implemented far less often in my experience but is useful for Subscribers that may be disconnected from a nework for long periods of time, when you want explicit control over when changes are applied to a Subscriber, or when you have a complex replication scheme with lots of Subscribers and you want to offload the Distribution workload to the Subscribers.

    Replication has been part of SQL Server for a long time and historically it has not changed all that much from one version to the next. While it is stable it is still one of the more complex sub-systems within SQL Server and one could get lost within all the various options. You are right to do lots of reading up front to make sure you pick the right type and configuration for your replication needs before deciding on a specific configuration.

    Implementing Replication Overview (SQL Server 2008 R2)

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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