?
Solved

Republishing (Replication)

Posted on 2004-08-12
6
Medium Priority
?
432 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

771 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