Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multiple subscribers for one publication Expand / Collapse
Author
Message
Posted Monday, September 9, 2013 6:08 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 4, 2014 8:05 AM
Points: 133, Visits: 283
I have two subscribers pulling from a single publication. I need to create a third subscriber. I would like to know if it would be better to add a third subscriber to the single publication or create another publication with the same articles as the first.
Post #1492958
Posted Wednesday, September 11, 2013 3:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 6, 2014 1:35 AM
Points: 178, Visits: 547
I would think just creating a new subscriber to the existing publication is better.
That is, if the articles being published are what you want on the 3rd subscriber.

If it is not necessary to keep the 3rd subscriber synchronized then you could also run a SSIS package one or more times a day to update it.




For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort
Post #1493513
Posted Wednesday, September 11, 2013 8:36 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 4, 2014 8:05 AM
Points: 133, Visits: 283
The third subscriber is for reporting so it has to be synchronized.
Post #1493726
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse