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:10:40
|
| Hi,we have around 20 applications, which each use a separate DB server. Each DB server locates in one sub company place. Now we need to integrate these applications. Since each sub company locates in different city, and the integrated application needs a part of data of each application, I am looking for a way to gather the required information from these DB servers. The number of DB servers may get increased continuously.MS SQL Server Distributed Partitioned Views let user gather information from a few linked servers so I think if we create those 20 or more DB servers as linked servers, I can create a Distributed Partitioned View to access required information, gathered from 20 servers, at once (please let me know if I am wrong). However, the question here is: 1. Is it possible to create linked servers on remote servers (not connected via LAN)?2. How security is applied to prevent data of those linked servers from being accessed by hackers?Need to mention that there are different database structure on each server, so it's not the matter of distributing tables horizontally or vertically. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-03 : 18:13:12
|
| Dup post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107591 |
 |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-08-03 : 23:55:39
|
| Thank you rmiao :) |
|
|
|
|
|
|
Linked Server