March 11, 2015 at 2:18 am
Hi Friends,
I have a SQL server 2008 R2 DB server which is setup for transactional replication. For some application requirement I removed an article from the publisher, but not dropped same from subscriber DB. Then I added few new columns to the table in publisher DB and now want to update same in subscriber DB.
I re-added the article in publisher, but same not updating in Subscriber. Kindly guide me on how to work out on such case.
Regards
Pradeep
March 11, 2015 at 4:25 am
I do this type of change on a regular basis, so your steps should be something like this (this is for a Pull Subscription):
1. sp_dropsubscription & sp_droparticle, to remove this table from Replication
2. Alter the table on the Publisher and the Subscriber
3. sp_addarticle
4. sp_refreshsubscriptions
5. sp_scriptpublicationcustomprocs may then be required to regenerate the procs required by the Subscriber. Just pick the procs out of the results that are required for the articles you have changed.
March 13, 2015 at 1:23 am
Thanks Braindonor for your reply.
Will you please do a favour explaining the steps in GUI.
Thankyou....
March 13, 2015 at 4:26 am
I never use the GUI, because it doesn't cater for the way we work here.
There is an Technet page for dropping/adding Articles with the GUI. You'll have to read further to see the impact on any snapshots.
https://technet.microsoft.com/en-us/library/ms152493(v=sql.110).aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply