报表数据库订阅者上的 SQL Server 2008 R2 分发者？
我必须设置一个用于报告的数据库，我为此选择了事务复制，因为它似乎是最简单的方法（设置必须很简单，我必须向客户解释如何做到这一点）。现在，我确实需要一个经销商数据库，并且我发现它不应该出现在出版商上的信息。由于只有一个订阅者，并且发布者的性能很重要，而订阅者的性能则不然，所以我正在考虑在订阅者上设置分发者。这有道理吗？有可能吗？
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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Flo，
是的，这是一种流行的配置。您需要在订阅服务器上配置分发，并使其充当发布服务器的远程分发服务器。在订阅服务器上配置分发并在发布服务器上创建发布后，您可以在订阅服务器上创建订阅。
远程分发服务器在配置分发和如何：配置发布和分发 (SQL Server Management Studio)。
希望这有帮助。
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.