SQL Server Replication - Configuring Subscriber | SansSQL

Wednesday, October 30, 2013

SQL Server Replication - Configuring Subscriber

In my previous post "SQL Server Replication - Configuring Publisher", we have seen how to configure the Publisher with articles and the next step in configuring replication is to configure Subscriber.

  • Expand the SQL Server Instance and then "Replication"
  • Right Click on "Local Subscriptions" and choose "New Subscription"
  • Click "Next"
  • This screen will allow you to connect to your publisher server

  • Once connected to the publisher server, choose the publisher from the list of available publications
  • In this screen, you can choose the subscription type by choosing from where the distribution agent should run

  • Specify the destination database
  • Here you have to specify the security for the Distribution Agent

  • In this screen, you can specify how frequently the data should get replicated to the subscriber

  • Choose the required options and click "Next"
  • Click "Finish" to start creating the Subscription

No comments:

Post a Comment