November 5, 2008 at 9:27 pm
I have a Transactional Publication.
I have created a new Stored Procedure that needs to be added to the Publication & then pushed to the Subscriber.
I know how to use the SP_ADDARTICLE to add the Stored Procedure to the existing Publication but how do I tell replication not to perform a full snapshot of the publication again?
In other words I just want to replicate to the subscriber just the newly added article in this case a Stored Procedure?
November 6, 2008 at 2:08 pm
If the Publication is setup correctly and you run the snapshot agent it should push newly added articles only.
We do this all the time.
* Noel
November 6, 2008 at 3:46 pm
Yes that it's exactly how I thougt it would work but unfortunately it performs an entire snapshot of the entire publication.
This is what I did.
1. Create new Stored Procedure
2. Add the Stored Procedure to the Publication
3. Right Clicked the Publication and selected "ReIntialise All Subscriptions". This brought up a dialog to select which snapshot or create a new one. The only option i could select was create a new snapshot as the other option was greyed out. I then clicked on the "Mark for ReInitialisation" and witnessed in Replication Monitor a snapshot of the entire publication when I thought it would have done only the new stored procedure.
November 7, 2008 at 11:09 am
You should simply re-run the snapshot agent.
Do *not* mark the subscription for re-initialization.
* Noel
November 9, 2008 at 5:11 pm
November 10, 2008 at 12:41 pm
Glad it worked out!
* Noel
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply