Wednesday, April 04, 2012 7:34 PM
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 ??
Wednesday, April 04, 2012 7:47 PM
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.
Wednesday, April 04, 2012 7:50 PMModerator
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.
- Marked As Answer by coolguy123SQL Wednesday, April 04, 2012 8:57 PM
Wednesday, April 04, 2012 8:52 PMExcellent Sanil... thanks a lot
Wednesday, April 04, 2012 8:53 PMthanks a lot ...