sql server replication: Same publication to mutliple distributors? -- sql server replication

Same publication to mutliple distributors?

Jen
9/20/2007 10:14:04 AM

sql server replication: SQL 2005 Can one transactional replication publication be sent to multiple
distributors - not direct to multiple subscribers? Basically we are not
allowed to place a local distributor on the source database server. We are
looking for ways to utilize have multiple publications on the same source
going to different distributors or same publication to different
distributors. Ideally we would have one dstributor but that is not our
scenario. Thanks for you assistance.

Re: Same publication to mutliple distributors?

Hilary Cotter
9/21/2007 5:49:47 PM

Other than using a gateway, no there is not.

A gateway involved publishing from one server to another, and this server in
turns publishes to a different subscriber using a different distributor.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]