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 |
|
notmyrealname
98 Posts |
 Posted - 2009-07-21 : 15:46:55
|
| Hi,I've created a VB.Net data application. I've created a database for this app on Server1. Some additional data that this application will display (read only) is on Server2. I simply created two datasets pointing to each server. From the start i did not have the resources to create a server link to access the Server2 data from Server1 so i opted to access Server2 with an ADO.Net dataset. Everything works fine. Recently, one of the IT guys created a server link between Server1 and Server2. It has been suggested that i now use the link.My question is:Since i already have a connection to the Server2 data built into my application, is there any benefit (or downside) to using the newly created server link. All of the info that i am getting from Server2 is for viewing only. I don't need to perform any joined queries between the two servers.Thanks. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-22 : 05:23:16
|
IMHOIf there is an instance in your company that has to control any access to servers and databases (from applications and other users) then you have to do what they have decided.Edit: typo
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
notmyrealname
98 Posts |
Posted - 2009-07-22 : 08:44:08
|
| Thanks for the reply.The thing is we are all trying to decide what works best. I am trying to get some input on why one approach might be better. It seems to me like the server link is just an unnecessary path to the data. Why point to a view on Server1 (that points to Server2) when i can just point directly to Server2?Again, thanks for the feedback. Any more will be greatly appreciated. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-22 : 08:50:17
|
So sorry I don't have profound knowledge about this.But my first step then would be to compare the performance of the different ways.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
ADO.Net dataset vs SQL Server Link