August 21, 2009 at 10:01 am
Hello,
We currently have a database that is set up to replicate two tables to a reporting database subscriber (with the subscriber pulling the publications). We need to add two new subscribers, which will also be used to generate reports, but these will only require some of the fields in one of the two tables that are already being published by the main database. So my question is, since these subscribers will require less data (one of the two published tables wont even be necessary), is it possible to configure the subscription to only pull some of the fields/tables specified in the publication?
I'm guessing the answer to my question above is negative, so my second question is: is it better performance-wise for me to create a new publication at the main database and have the subscribers pull from this new publication or is it better to use the already existing publication even though I'll only use part of the information at the subscriber? Our bottleneck is the main database, since the subscribers are used to generate reports and all the vital information is updated at the main database.
Thanks
August 21, 2009 at 12:35 pm
From What I see, you already have an existing publication, therefore it is better to use the same publication and two new subscribers. The Distributor will have to work harder but the publisher has to publish only once. You dont loose anything by having additional data in the two new subscribers.
Just my two cents
-Roy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply