Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ceffster
Starting Member
2 Posts |
 Posted - 2010-01-23 : 12:58:37
|
| I currently have a problem and I'm not sure if it's even possible to do what I need done. Hopefully someone can either point me in the necessary direction OR confirm that I am not able to do this.Scenario:Master Server has Linked Servers A & B.From the master server I run a Query on one of the Views that is on Link Server A... (Data results)I want to then automatically send these results to Link Server B.Another option I thought of is: From the master server I run a Query on one of the Views that is on Link Server A... (Data results)I want to then automatically send these results to Master Server then send them to Link Server B.Are either of these options possible?Option 1: Minimizes replication & is more direct process.Option 2: Creates replication, but would then create larger workloads on the servers over time when the results get larger.Currently Setting up Link Server B to directly link to Link Server A is not an option.SQL: Simply Question Logic |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-24 : 05:08:53
|
| "send these results to Link Server B"What do you mean by this? Insert them into a table on Linked Server B??If Linked Server A can see Master, and Master can see Linked Server B then surely it must be possible to allow Linked Server A to directly see Linked Server B? Doing it in two steps not only adds "replication"/duplication of data, but will make the process much more fragile as well. |
 |
|
|
Ceffster
Starting Member
2 Posts |
Posted - 2010-01-24 : 13:54:31
|
| Yes inserting the data into a table on Link Server B.SQL: Simply Question Logic |
|
|
|
|
|
|
Linked Servers.