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 |
|
cbeganesh
Posting Yak Master
105 Posts |
 Posted - 2008-02-06 : 10:33:50
|
| currrently we have a sql server stored procedure to get data from a sql server db on the same machine. The data is going to be moved to db2 on a unix machine. Is it possible from sql server to connect to db2 to get the data from db2 tables. Please let me know the diffrent methods. will it be slow to acces the data from db2. The db2 is in a diffrent location.ThanksG |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-06 : 10:44:04
|
www.connectionstrings.comUse Linked Server.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-02-06 : 10:46:55
|
| Thanks .I also wanted to know if the performace will be affected , since the db2 will be on a diffrent place than the sql server |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-06 : 23:20:57
|
| It depends on link speed between sql server and unix. |
|
|
|
|
|
|
sqlserver to db2