August 8, 2005 at 10:04 am
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 ?
August 10, 2005 at 12:06 pm
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