Solved

Republishing (Replication)

Posted on 2004-08-12
6
424 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:dishanf
  • 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:dishanf
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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 backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now