Wednesday, March 7, 2012

Publisher and Subscriber on the same SQL Server

When using "Merge Replication", is it possible to have a SQL Server to
be a Publisher for one database and a Subscriber for another? I'm not
a SQL gury and was hoping someone out there can lend me a helping hand.
yes you can
"mordac" wrote:

> When using "Merge Replication", is it possible to have a SQL Server to
> be a Publisher for one database and a Subscriber for another? I'm not
> a SQL gury and was hoping someone out there can lend me a helping hand.
>
|||Most definitely - I test most scenarios using one instance only.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment