Installing Transactional Replication
In this section we will learn how to install Transactional Replication using wizard and using T-SQL. We will also learn about which account should be used to run SQL Server Agent.
Creating new publication for Transactional Replication
Let's start installing transactional replication by creating a new publication.
- We need to connect to the server on which we want to create publication. Expand the replication node, right-click on Local Publication, and select New Publication.
- In the Publication Database dialog box, select the database to be published.
- In the Publication Type dialog box, select the Transactional replication. ...