Post reply

PULL Transactional Replication in SQL Server 2005

  • July 6, 2009 at 5:29 am

    #207866

    I am new to SQL Server 2005 Transaction Replication.

    I have two SQL Server 2005 (with SP2) systems and need to implement the Transactional Replication using PULL technology.

    The setup need to be in this way....For example.

    Server A - acts as the Distributor and the Subscriber

    Server B - act as the Publisher.

    I want to transfer the entire table data from "Server B" to "Server A" using the PULL Transactional Replication.

    Any good example, on how to set up PULL Transactional Replication (From start to end) will be helpful (OR) any books related

    to this kind of example (OR) any link will help me resolve the issue.

    Thanks in Advance.

    Regards

    Nan.

  • July 6, 2009 at 5:40 am

    #1020294

    Three basic steps are

    1. configure distribution

    2. configure publication

    3. configure substription(s)

    Since you're keeping your distribution and subscriber on the same server, i dont think there will be much difference between pull and push subscription.

    The following article explains on how to setup transactional replication.

    http://blogs.techrepublic.com.com/howdoi/?p=123

    Also, all your tables in the source database must have a primary key on them.


    Pradeep Singh

  • July 8, 2009 at 8:03 am

    #1021667

    Thanks for your kindful information. I was able to set it up successfully.

    Nan.

  • July 8, 2009 at 8:13 am

    #1021673

    Hi Nanda,

    Take a look at replication monitor also. It will help you to monitor and troubleshoot replication. You can find lot of references on the net on how to use. Try google.

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

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

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