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 |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-08-03 : 08:31:26
|
| Hi, Can federated database servers be created on databases with different DB structures?I need to read data from different databases located on different servers in one view.Any idea is appreciated |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-03 : 13:56:29
|
| Federation is just partitioning your data across SQL instances, which it doesn't sound like you are doing. It sounds like you are just trying to combine data in a view rather than splitting data up using a view.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-03 : 18:10:29
|
| You can do that via linked server. |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-08-03 : 23:59:59
|
| yes I'm not going to partition data, so am going on for linked servers |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-04 : 00:26:02
|
| You will probably want to test the performance of this in a mock production environment. If performance is slow (which I suspect it will be), you may want to replicate your data from all of the different sources into a main database.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
Federated DB