[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Republishing (Replication)

Posted on 2004-08-12
6
Medium Priority
?
436 Views
Last Modified: 2010-08-05
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.


0
Comment
Question by:Dishan Fernando
  • 3
4 Comments
 
LVL 8

Expert Comment

by:SNilsson
ID: 11791432

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.

0
 
LVL 8

Author Comment

by:Dishan Fernando
ID: 11791442
But whats the meaning of Republishing ? BOL says posible to doing this
0
 
LVL 8

Expert Comment

by:SNilsson
ID: 11791475
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."
0
 
LVL 8

Accepted Solution

by:
SNilsson earned 1500 total points
ID: 12065032
"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 recommend....me :)

I did answer his question, I belive.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question