SQL Server Performance

Add/drop colum in repl DB

Discussion in 'Performance Tuning for SQL Server Replication' started by motioneye, Jul 25, 2005.

  1. motioneye New Member

    Hi..
    I would like to know what would be happen if I just simply add/drop the column in repld db??? Or If I have added extra tables/column in production db do I need to do the same thing in repl db or do I need to rerun the snapshot agent?
  2. satya Moderator

    You can use sp_repladdcolumn sp_repldropcolumn to add or drop columns to a previously replicated table. You can also modify this via the UI on the article properties page.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Ray D New Member

    If you add a new table to the publication, you will need rerun snapshot agent.

    WBR, Vlad A. Scherbinin
  4. motioneye New Member

    Rerun the snapshot but it does not replicate the new table.
    Last action msg: A snapshot was not generated because no subscription needed the initialization
  5. ghemant Moderator

  6. motioneye New Member

    I wanted to know how do we replicate the new table from publisher to subscriber..
    I know how to add/drop column...
    so is there any way that i can replicate the new table without initialize the shema and data ?

Share This Page