Adding new column to an article in existing publication(Transaction replication)

• Aspet Golestanian Namagerdi

  SSCarpal Tunnel

  Points: 4444

  More actions

  February 12, 2015 at 3:22 pm

  #315271

  Hi Everyone,

  We have a Transactional replication in SQL SERVER 2008R2, in which we are publishing 7-8 articles. Some of these articles are very large tables. we have two subscribers for this publication.

  Now we want to add a new column to one of the articles in this publication. Is there an easy way to do that without intialization of subscribers? If I add them directly to the article it will ask me to create a snapshot and reintialize the subscribers, which will be an outage for us.

  I would appreciate fi someone help me on this issue.

  Regards