SQL Server 2008 R2 Distributor on Subscriber for Reporting DB?

I have to setup a database for reporting, and I chose transactional replication for that because it seems the easiest way (setup has to be easy, i will have to explain to customers how to do that). Now for that i do need a distributor database, and i found information that it should not be on the publisher. As there will only be one subscriber, and the performance of the publisher matters alot and the performance of the subscriber does not, I was thinking of setting up the distributor on the subscriber. Does that make sense and is that even possible?

Answers


Flo,

Yes, this is a popular configuration. You'll want to configure distribution on the Subscriber and have it act as a remote Distributor for the Publisher. After configuring distribution on the Subscriber and creating the publication on the Publisher, you can then create the subscription on the Subscriber.

Remote Distributors are covered in Configuring Distribution and in How to: Configure Publishing and Distribution (SQL Server Management Studio).

Hope this helps.


Need Your Help

How to add a unique occasion for different observation dates within an individual in R?

r

I'm trying to figure out how in my data set to add a column including a count of unique events based on date within each patient. Here is a part of my data set:

urllib2 times out but doesn't close socket connection

python http sockets timeout urllib2

I'm making a python URL grabber program. For my purposes, I want it to time out really really fast, so I'm doing

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.