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.



    Thanks

    BK


    Bhushan Kalla
  2. satya Moderator

  3. MohammedU New Member

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

    http://msdn2.microsoft.com/en-us/library/ms146887.aspx


    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    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.

    Thanks,
    Bhushan

    Bhushan Kalla
  5. GopalMynam New Member

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

Share This Page