SQL Server Performance

Adding column changes to replicated Tables

Discussion in 'Performance Tuning for SQL Server Replication' started by kevi322000, Mar 10, 2006.

  1. kevi322000 New Member

    Is there a easy way to do the following that would not require re doing the entire snapshot of other tables. (Transactional Replication)

    1. I have a group of tables in a publication that are being replicated.
    2. I need to change one table to add a aditional column.
    Question: Is there a easy way that would not require redoing all the other tables, but just the one I changed to be pushed to the subscription servers?

    kevi322000
    kevi322000, Mar 10, 2006
    #2

  2. satya Moderator

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=13313 for relevant information.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Mar 10, 2006
    #2

Share This Page