Starting a new app that will be drawing data from two databases, both db's will be Sql Server 2005. At the moment both dbs are also on the same server but would like to leave some flexibility of this possibly changing in the future.
For the most part, data drawn from the one database will be used only to fill datasets and used as look-up data; so there wont be much updating to that database; although there will be some.
Ok my question is which would be the most opitimal and provide the best performance, using linked servers or using a seperate connection object to the second database within my vb app?
If someone can provide some pro's and con's of both ways for a comparison it would be appriecated.
For the most part, data drawn from the one database will be used only to fill datasets and used as look-up data; so there wont be much updating to that database; although there will be some.
Ok my question is which would be the most opitimal and provide the best performance, using linked servers or using a seperate connection object to the second database within my vb app?
If someone can provide some pro's and con's of both ways for a comparison it would be appriecated.
