Republishing (Replication)

Hi experts.
I want to republish data in sql server. Scenario is like this.

SERVER A           SERVER B                        SERVER C
Publisher    -->    Subscriber/Publisher  -->  Subscriber

Server A publish data (Merge/push to SERVER B)
Server B publish data (Merge/push to SERVER C)

Can be done this type of publishing.?
Is there any way to doing this type of publishing.

Dishan FernandoSoftware Engineer / DBAAsked:
Who is Participating?
SNilssonConnect With a Mentor Commented:
"I would appreciate any comments by the experts that would help me in making a recommendation."

Well, since I'm the only one here, I would :)

I did answer his question, I belive.

Cant you use SERVER A as publisher to both B and C (or is there other data on B that dont exist on A ?)

For complicated data merge and datawarehouse solutions, I think that I would have buildt it in DTS instead.

Dishan FernandoSoftware Engineer / DBAAuthor Commented:
But whats the meaning of Republishing ? BOL says posible to doing this
Yes it is, and used to save/optimize bandwith when slower connections exists for exampel.

From Booksonline:
"The republisher model uses two servers to publish the same data. The Publisher sends data to a Subscriber, which then republishes the data to any number of Subscribers. This is useful when a Publisher must send data to Subscribers over a slow or expensive communications link. If there are a number of Subscribers on the far side of that link, using a republisher shifts the bulk of the distribution load to that side of the link."
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.