SQL Server Performance

Add a new table to Transactional Replication

Discussion in 'SQL Server 2005 Replication' started by iambhushan, Jul 24, 2007.

  1. iambhushan New Member

    Dear Friends,

    I have a transactional replication set up in my environment and it's running fine. Now I wanted to add a new article (Table) to the publication with out generating a new snapshot because the snapshot generates hugh file (Database size is 200GB, new table has 160 million records) and locks the tables momentarily. Instead I add the new table's schema on both publisher and subscriber and move data to subscriber using DTS/SSIS. After that add the article to the publication using sp_addarticle to the existing publication. But some reason this method is not working. If anyone knows how to do a table to the existing publication with generating snapshot file please let me know.



    Bhushan Kalla
  2. satya Moderator

  3. MohammedU New Member

    Check BOL topic "How to: Define an Article (Replication Transact-SQL Programming) "


    Microsoft SQL Server MVP

    All postings are provided “AS IS” with no warranties for accuracy.
  4. iambhushan New Member

    Thank you for both Satya and Mohammed. I will try this.


    Bhushan Kalla
  5. GopalMynam New Member

    Have you find out the method to add a new table to publishing without creating new snapsot.

Share This Page