January 21, 2010 at 12:42 am
I have a problem regarding replication on SQL server 2005, running transactional replication.
Publisher server A having 1000 tables and it is publishing 1000 table for Subscriber B which is used for reports.
I Need to add one more subscriber C which will Subscribe only 300 tables from publisher A . can we add filter for articles at subscriber in pull subscription.
Suppose Publisher A publishing 1000 tables with publication name PUB1 Server B is already Subscribing PUB1.
I need to add one more subscriber which will subscribe 300 table from pub1.
Is it possible. then suggest me how can I configure this.
January 21, 2010 at 11:21 am
Create a new publication on server A specifically for subscriber server C that only includes those tables.
January 23, 2010 at 7:30 pm
Can we think of creating publication for these 300 articles at Subscriber B? As 1000 tables are published from publisher so there is too much load on publisher. I am much sure of this.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply