Setting up transactional Replication in SQL Server

Published on September 5 2015 by LakshmiSaahul,Dhana Royal

PULL Replication Setup on 3 database servers. Where Publisher, Distributor and Subscriber all are in different servers

1) To set up distributor

· Go to distributor server

· Click on replication folder

· Click configure distribution

2) To set up publisher of distributor (Password setting which will be used while creating publication on publisher Instance)

· Go to distribution server

· Click on replication folder

· Click distributor properties

· Click on publishers

· Add the publisher you want to add

· And provide password

3) Creating publication and article on publisher Instance

· Go to publisher server

· Click on replication folder

· Click on local publications

· Click on new publication

· Select database and publication type

· Select article

· Provide security

4) Setting up subscription on Subscriber

· Go to subscription database

· Click on replication folder

· Click on local subscription

· Click on new subscriptions

· From publisher combo box

· Select Find sql server publisher

· Slect the sql server publication instance

Corresponding SQL Commands if you want to set up using SQL Scripts:

Advertising