Add a new table to Transactional Replication

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

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.

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

Thanks,
Bhushan

Bhushan Kalla

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