I would just like to know is that possible that to alter the table (as in add in new columns to tables or changing the field type) in a published merge replication? Currently what I have to do is stop the replication, delete the subscription, take the table out from the published list, alter the table and put everything back on, but its kinda slow as the snapshot agent needs to run again which then copy all the data across again (I know I can assume the subscription have the schema and data so not copying the data across). But I'm sure there should be some other ways to do it, since I should be able to change the shema of in the published tables and it should flow through to all other server isn't it? Or is there any other method to do this?
Thanks for all the help.