January 22, 2004 at 5:01 am
Hi!
I have a publication with a number of articles. Is it possible to replicate only some of them to one of the subscribers? I.e.: suppose we have 7 articles (tables) in one publication and would like to subscribe only 3 of them to subscriber1 and all 7 to subscriber2?
(This is all about transactional replication on MS SQL Server 2000 Ent sp3)
Thanks.
January 25, 2004 at 12:59 pm
Hi,
strictly speaking, subscriptions are per publication, not per article, so the simple answer is no - using standard techniques. However, I have partitioned data according to subscriber using the integration of DTS and Transactional Replication. This is straightforward using merge, where you have access to the HOSTNAME parameter for the agent, but in transactional you have to be a bit more circumspect and create a separate DTS package per subscriber. See details on http://www.replicationanswers.com
Regards,
Paul
Paul Ibison
Paul.Ibison@replicationanswers.com
January 27, 2004 at 2:06 am
Just found a couple of SPs and wonder if this will work:
1. You create a publication with N - articles
2. Subscribe all servers that need at least one article from it.
3. Use:
sp_dropsubscription @publication = 'publication',
@article = 'article',
@subscriber = 'subscriber'to remove the articles not needed on particular subscriber.
4. If you need them back, use:
sp_addsubscription @publication = 'publication',
@article = 'article',
@subscriber = 'subscriber' How about it?
January 27, 2004 at 2:11 pm
Hi,
The GUI makes supporting it a bit more difficult (opaque) and it is restricted to differently named servers as subscribers (ie no 2 subscribers on the same server) but I've seen this as a solution before and it works fine.
Cheers,
Paul
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply