| Author |
Topic |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-07-29 : 05:58:26
|
| 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'm looking for a way to gather the required information from these DB servers. The number of DB servers may get increased continuously. I need a good solution soon so any idea would be appreciated Please help me to clarify my problem,if required. |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-07-29 : 08:58:45
|
| 11 people have read my msg and no one answered :) I was thinking about viewing my problem in another way: There are some companies that implement a site and send it to other companies so that the buyers can advertise for their own on those site and chat through that site with their colleges in other branches. The site price is according to the number of users who want to has access to that site through one company. though each company runs the site on his own DB server, the main company needs access to their server to check their users numbers, while the DB servers are located in different countries. I need to know how they do that. This is the same problem as mine actually :)Any idea? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-29 : 23:09:09
|
| Can you connect to those servers? If so, you can access those sql instances once get proper permission. |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-08-01 : 23:39:04
|
| Thanks for your reply rmiao.I'd like to know how to connect to those servers,located in other cities |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-01 : 23:43:50
|
| Any network connection to those servers? Like vpn or so? |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-08-02 : 00:17:45
|
| I would manage it if required.But the question is,does application have to connect to 20 servers or more,one by one, to gather information for one query? isn't there any DB server architecture to facilitate such requirements? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-02 : 14:13:36
|
| Not sure what you mean, you have to connect to server to find out what happens on it. |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-08-03 : 08:09:22
|
| 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'm 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? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-03 : 18:14:24
|
| 1. you need kind of connection like vpn.2. you can map local sql login to remote ones in linked server. |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-08-03 : 23:58:09
|
| so the MS SQL Server Distributed Partitioned Views and linked servers is the solution right?Could you explain more about #2? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-04 : 23:38:22
|
| It's kind of set access permission on linked server, find details in books online. |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-08-05 : 00:57:03
|
| Thank you rmiao for your immediate replies and good comments |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-05 : 01:00:44
|
| Why isn't transactional replication being considered?I don't think partitioned views will work for you since you've mentioned the schemas are different (I think in another one of your threads).Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-08-05 : 02:38:02
|
| yes schemes are different, that was one of my questions if partitioned views work on different schemes. However, let's forget partitioned views, imagine we have linked servers,can't we create a view, which reads from tables of different schemes stored in different servers? By the way, I'm afraid, I'm not brave enough to tell my company manager that I can support transactional replication on servers located on WANThanks for your reply |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-05 : 12:46:58
|
| The linked server approach will be very slow, most likely, if not used with partitioning. You should do a trial of this scenario in a test environment.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
DB Integration