June 28, 2011 at 9:49 am
I am running snapshot replication and trying to script the publication. I have included all columns for the tables being replicated. When I generate the scripts, the @vertical_partition is set to 'true' instead of 'false'. This results in scripting sp_articlecolumn for each column.
The problem with that is that the upgrade will add new columns to some of the tables and when I rebuild replication, these will not be included.
Is there something I'm missing when scripting or any way to change the scripting behavior?
Thanks,
Kim
June 29, 2011 at 2:11 am
With a verticle partition it is likely there is one or more columns already not published. It may have been in the past so the tables match, but currently, changes to this column do not replicate.
If the columns are added to a table with the publication option of replicate_ddl=false, new columns will not be replicated.
You can add a column without changing the publication using sp_repladdcolumn.
Or you can enable option using sp_changepublication.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply