Changing Column Filters in Trans Repl

  • Currently, I'm using transactional replication, and filtering on specific rows. I'm considering filtering specific columns as well, to save space & time.  If I select 10 colums to replicate, and then decide a month later that I want to replicate an additional column, how much of a pain will that be ??   

    The table at the subscriber will only have 10 fields, so somehow an 11th field will need to be added & backfilled with the missing data.

    Will I need to re-snapshot, or is there a work-around ?

  • If you want to add a new column to the table (not the filter) then you can use sp_repladdcolumn and with this there is no need to generate a new snapshot. Also there is no need to stop the server as Microsoft says. There are a few tricks to achieve this.

     

    But if you want to add an existing column to the filter, then you will have to generate a new snapshot.

     

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply