When i add e new table its not getting replicated automatically

Question

hi I have a replication set up : i have 5 tables which got replicated initially when i set up replication , and also when i insert data into that it gets replicated, but when i create a new table its not getting replicated ? do i need to edit publisher setting and mark this table and every table which i add  again again to subscribe and  initialize the subscription again and again ? i dont  think so ,  it should be automatic i guess ..

can any one let me know in transactional replication : having publisher and distributor in same machine :how if a table gets added replicated to Subscriber ??

Thanks

Answer 1

Hi,

Every table/object marked for replication is a separate article in the publisher set up. Since replication gives you the ability to pick & choose which tables/objects you want to replication and which you don't - when you create a new table, replication cannot pick it up automatically. you will need to go into the publisher properties > click of articles > and add a check mark against the newly created table. Only then, replication will pick it up and replicate it. This is true for both transactional and snapshot replication. This behavior is the same, no matter if the publisher and distributor are on the same machine or different machines.

Here is a link to a technet article if you are looking for more information on this topic. http://technet.microsoft.com/en-us/library/bb677158.aspx 

Hope this helps ! 

---

Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer.

Answer 2

Adding an a new article involves adding the article to the publication, creating a new snapshot, and synchronizing the subscription to apply the schema and data for the newly added article.  Reinitialization is not required, but a new snapshot is.

This is covered in Add Articles to and Drop Articles from Existing Publications.

---

Brandon Williams (blog | linkedin)

Answer 3

Excellent Sanil... thanks a lot

Answer 4

thanks a lot ...