December 1, 2011 at 9:09 am
hello guys, i currently have a transactional replication set up with 100 articles. I am adding a few columns to some of the articles, my question is regarding the parameter @force_reinit_subscription, when setting up a new publication for the first time i put @force_reinit_subscription=1, but if i am only adding to an existing publication should'nt the parameter be set to @force_reinit_subscription= 0 so then the whole subscription doesn't reinitialize?
To make my question more clear, Does parameter @force_reinit_subscription=1 makes the subscription for ALL articles reinitialize or only the article that are being modified?
December 2, 2011 at 2:16 pm
DBA-640728 (12/1/2011)
hello guys, i currently have a transactional replication set up with 100 articles. I am adding a few columns to some of the articles, my question is regarding the parameter @force_reinit_subscription, when setting up a new publication for the first time i put @force_reinit_subscription=1, but if i am only adding to an existing publication should'nt the parameter be set to @force_reinit_subscription= 0 so then the whole subscription doesn't reinitialize?To make my question more clear, Does parameter @force_reinit_subscription=1 makes the subscription for ALL articles reinitialize or only the article that are being modified?
By setting this parameter you are reinitialising the subscriber. Thats every single article.
Set it to 0 and just run a snapshot to generate just the article changes.
If you've just added columns and you are replicating DDL you wont need to anything. If you arent, you can still use sp_repladdcolumn to publish the new columns with no extra work.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply