Creating Subscriptions

Now that you have installed and configured the distributor, enabled publishing, and created a publication, you can create subscriptions.

Remember that two types of subscriptions can be created: push or pull. Pull subscriptions allow remote sites to subscribe to any publication that they are allowed to, but for this to work, you must be confident that the administrators at the other sites have properly configured the subscriptions at their sites. Push subscriptions are easier to create because all the subscription processes are performed and administered from the publication/distributor point of view. This also makes using them the most common approach.

For this example, we use the New Subscription Wizard to create a push ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.