Sunday, March 25, 2012

Additional articles added ..

I was going through this link and had a question with regards to caveats
when new articles are added
The link is http://www.replicationanswers.com/No...alizations.asp
So Say i have nosync initially setup and everything is going on fine. I now
want to add new articles to the publication.
Can i not just do an sp_addarticle followed by a sp_addsubscription with
@.sync_type='automatic' and then run the snapshot agent.
Will that not apply the snapshot for just these new articles ?
Using Transactional Replication
Thanks
Yes, you're quite right. Section 2.1 is referring to the gui, but it is
possible to mix noinit and automatic in the same publication by scripts.
I've put this in as an interesting aside (attributed to yourself ),
although I maintain that this could lead to unmaintainable publications.
Rgds,
Paul Ibison
sql

No comments:

Post a Comment