Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 PULL Transactional Replication in SQL Server 2005

Author  Topic 

onlysubscribe
Starting Member

2 Posts

Posted - 2009-07-06 : 07:17:24
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.

Thank you in Advance.

Regards
Nans.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-07-07 : 22:40:22
books online has complete/detailed instructions on setting up replication.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

onlysubscribe
Starting Member

2 Posts

Posted - 2009-07-08 : 09:57:57
Thanks for your kindful information. I was able to set it up successfully.

NR
Go to Top of Page
   

- Advertisement -