sql server replication: Need to add merge article -- sql server replication

Need to add merge article

Chris
12/14/2005 2:29:28 PM

sql server replication:

SQL 2000 sp4 - I have an existing merge publication, I want a new table. I
assume I would do the following, however I have some questions:

I assume I call sp_addmergearticle, for the @article param, specify the new
table.

I also assume I would need to call sp_addmergesubscription, correct?

I do the similar for transactional repl, however when I call
sp_addsubscription I can specify the new article in the @article param, set
sync_type to automatic, run the snapshot agent and a snapshot is generated
for only the new article. My concern is I do not see an @article param for
sp_addmergesubscription... When the snapshot agent fires, will it run for the
new article only?

Any insight would be appreciated.

Thanks,

RE: Need to add merge article

Chris
12/14/2005 4:25:44 PM

Scratch this... all you need is sp_addmergearticle, unfortunately a snapshot
is generated for ALL articles (locking up my prod tables), however only the
added article is sent thru the merge agents...

Thanks anyway.

[quoted text, click to view]

Re: Need to add merge article

David
12/15/2005 3:35:04 PM

Besides sp_addmergesubscriptions, don't you also need to run a new snaphot?
Or does this get replicated on each subscriber?

David

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.