Tag: Replication
-
Transactional Replication – Configure Subscriber
Unlike previous versions, of SQL Server 2005 allows you to use the same wizard to create either pull or push subscriptions. Perform the below steps to Configure Subscriber
-
Transactional Replication – Configure Publication
Once youve configured a distributor, youre ready to create publications. Perform the below steps as follows, Step1 : Connect to an instance (Sansu) of SQL Server by using the SQL Server Management Studio (SSMS), navigate to the “replication” folder then local publications folder, right-click this folder, and select New Publication. This invokes the new publication…
-
Transactional Replication – Configuring Distributor
Lets Discuss the steps to Configure Distributor in detail. In this article I am using the Server SansuTest as the Distributor. The Distributor is configured from SSMS as follows :
-
Replication Components and Agents
Replication Components SQL 2005 replication is based on the Publish and Subscribe metaphor. Let us look at each of the individual components in detail.