Adding an article to an existing pull transactional publication

Question

Adding an article to an existing pull transactional publication

DKlein

SSCrazy

Points: 2351
More actions
May 16, 2011 at 2:16 pm

#239747

Hey All,
I am trying to add an article to an existing pull transactional publication. By adding the article in SSMS to the publication through the properties, then starting the snapshot agent. Snapshot agent completes, with no new table on the subscriber side. I checked 'View Synchronization Status' on the subscriber under Replication - Local Subscriptions - Right click on the subscription and View. It is constantly running and the View Job history is blank.
Back story: this subscription was initialized with a backup if that helps.
Any advice would be appreciated,
Thanks,
DK

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29384 More actions · Answer 1

You have missed a step - you need to add a subscription to the new article. Once that is done, the distribution agent becomes aware that it needs to deliver the table and its data to the subscriber.

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 2

happycat59 (5/16/2011)
You have missed a step - you need to add a subscription to the new article. Once that is done, the distribution agent becomes aware that it needs to deliver the table and its data to the subscriber.

That would normally be done automatically through the gui.

This is one of the reasons why replication should be done manually through tsql. Happycat59 is correct, replication is granular down to the article level so a once a article is added you need to subscribe to it.

DKlein SSCrazy Points: 2351 More actions · Answer 3

Thanks for the replies happycat59 and MysteryJimbo! Should I use the example script from the link below for adding a table to the publication?

http://msdn.microsoft.com/en-us/library/ms173857.aspx

My table addition has no filtering.

Thanks again,

DK

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 4

I would generate the scripts from the existing publication (right click context menu) to get the existing setting from another table article and use that as a template.

You will also be able to get the existing sp_addsubscription's out of this script and be able to reuse them as is to add the new article to the subscribers.