SQL Server Performance

Adding column to transactional replication

Discussion in 'SQL Server 2008 Replication' started by Oscar, May 26, 2011.

  1. Oscar New Member

    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?
    Oscar, May 26, 2011
    #1

  2. dineshasanka Moderator

    If you have added entire table to the replication and your DDL replication is set to on(which is by default), it will be added to subscriber automattically.
    but, what is the size of your table. if it is a large table, first add the coulmn with null values without defaults and then update it.
    dineshasanka, Jun 21, 2011
    #2

Share This Page