Solved

Republishing (Replication)

Posted on 2004-08-12
6
428 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 500 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

696 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