all groups > sql server replication > may 2005 >
You're in the

sql server replication

group:

Additional articles added ..


Re: Additional articles added .. Paul Ibison
5/20/2005 12:00:00 AM
sql server replication: 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

Additional articles added .. Hassan
5/20/2005 12:14:48 PM
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/NoSyncInitializations.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

AddThis Social Bookmark Button