I am running transactional replication on a large database (+300GB) to a single subscriber. I have replicate schema changes turned off. I want to add a column to a table and have the data replicated across. From my research I belive this means I need to reinitialize the subscription so it picks up the change the article. As you can imagine I want to avoid the reinitialize due to the size of the database. Is there a way to add a column to the replication without reinitializing the whole subscription? Can I reinitialize just the one article? If not, what is the best way to reinitialize without needing to get a snapshot from the publisher, e.g. restoring a backup?