Contents
How to create a subscription to a transactional publication?
In the section Create a subscription to the transactional publication, see step 5. The name of the subscriber instance is not displayed, so I click Add Subscriber, and then click Add SQL Server Subscriber from the drop-down list. Then the Connect to Server dialog box appears.
How to query list of subscriptions and articles?
In Sql Server 2014, how to query a list of Subscriptions & its articles for a given Publication from Publisher? (transactional replication) Yes, there are easier ways to query from Distributor but I need a query from Publisher side. Found this sys proc, not sure if it is correct.
How do I add a subscriber to SQL Server?
The name of the subscriber instance is not displayed, so I click Add Subscriber, and then click Add SQL Server Subscriber from the drop-down list. Then the Connect to Server dialog box appears. I enter the subscriber instance name, switch to SQL Server Authentication, fill out the sa username and password, and then click Connect.
How to find the pubid of a publication?
Look in syspublications to see a list of the publications set up on the publisher database. Hopefully you will be able to see one with a description that identifies the subscriber database you are interested in. Take note of the pubid of the publication you are interested in:
How to add new article to existing publication?
To create a new snapshot for a merge publication with parameterized filters, see Create a Snapshot for a Merge Publication with Parameterized Filters. After the snapshot is created, synchronize the subscription to copy the schema and data for the new article. To synchronize a push subscription, see Synchronize a Push Subscription.
When to add the function to the publication?
When you add the function to the publication: specify a value of 1 for the @processing_order parameter of sp_addmergearticle; and specify a value of 2 for the @processing_order parameter of sp_changemergearticle, specifying the table name for the parameter @article.
When to drop an article after a subscription is created?
For snapshot or transactional publications, articles can be dropped with no special considerations prior to subscriptions being created. If an article is dropped after one or more subscriptions is created, the subscriptions must be dropped, recreated, and synchronized.
How to add an article to a publication?
As noted in Adding Articles to and Dropping Articles from Existing Publications, you must* create a new snapshot for the publication. To avoid generating a snapshot for all articles when adding a new article, publication property immediate_sync must be set to 0.
How to add Article to transactional publication without SQL Server?
After you add the article you can simply start the snapshot job and you will notice that it only generates a snapshot for the new article (called a mini-snapshot). Then check your distribution job, and notice that it created the table at the subscriber and bulk-copied your data.