UncleBoris (4/14/2013)
I am doing some testing with Replication, I have not used much replication before.I have set up a Subscription that uses Transactional Replication and works fine when I update or insert.
I added a new table, went to the Publisher and added the table as a new Article.
I could not see the new table in the Subscriber database.
In the end I did a "ReInitialize" at the Publisher with creating a new Snapshot.
I can see the new table and the errors have gone.
Is this the correct way to get the new article to the Subscriber?
Yes, It wouldn't appear in the subsriber otherwise.
When it does this new Snapshot does it consist of the ALL the Articles and data (could be big) or just and changing like the new table?
It will include all the articles. It is possible to take snapshot of only the added article if you disable some options in publisher and then run snapshot agent.
--Run on your publisher database
EXEC sp_changepublication @publication = 'your publication name',
@property = 'allow_anonymous' ,
@value = 'false'
GO
EXEC sp_changepublication @publication = 'your publication name',
@property = 'immediate_sync' ,
@value = 'false'
GO
M&M