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