Two Publishers on One Server… | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Two Publishers on One Server…

I’m using merge replication with a Publisher and 26 Subscribers. I have another server that is using merge with another 5 Subscribers. Question…Can I move that Publisher onto the server that currently has the Publisher on it? Will there be confusion in the distribution database as it will be working with two different merge replication "profiles", etc. Thanks in advance,
SThompson
Hi there, each publishing database can have multiple merge replication publications, and a single server can have multiple publishing databases as well. so yes you should be able to move the database from the second server onto the first and configure the publication/subscriptions Cheers
Twan
True, you can support many publishers to one distribution database, but there may be cases where you want to separate logical replication applications into separate databases, for administration purposes. In some cases, there may also be a performance benefit because you may have reduced contention (both writing to and reading from the distribution database). The publisher and subscriber can never have the same priority; SQL Server enforces this while adding subscriptions. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>