April 20, 2012 at 10:07 am
OK, I'm driving myself crazy trying to find an answer I can understand to my problem. I have a lot that get close but something always throws me off. Here's my situation:
I have transaction replication setup and one of my publications consists of one article (table) that has vertical filtering. At some point, the replication procedures got updated to include additional columns in the table but the vertical filtering in the article did not get updated. Now, when replication tries to occur, it is not sending over all of the columns needed to run the replication procedures.
The tables are the same on both the publisher and the subscriber. So, what I want to do is simply add the columns that are not currently part of the vertical filtering into the replication BUT I don't want to mess with any of the data that has already been replicated.
I'm confused about the snapshot and re-initialization. Since all I want to do is pick up replicating these new columns without changing any existing data, how do I go about this? The following is an example:
Table A has five columns (in both publisher and subscriber): ColA, ColB, ColC, ColD, ColE
Only the following columns are chosen for replication: ColA, ColB, ColC
The replication procedures are expecting all five columns.
What is the best way to add ColD and ColE without causing any problems with the existing data?
Thanks!
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
April 20, 2012 at 2:30 pm
If it's not a lot of data I would probably drop the article then add it the way that it should be. After that, run the snapshot job so it picks up the new article and reintializes the subscriber.
April 21, 2012 at 4:26 pm
i had to do something similar and this post http://www.sqlservercentral.com/Forums/Topic310849-291-1.aspx helped me. You can just copy the changes without re-setting entire replication.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply