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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-07 : 10:11:11
|
| Doug writes "I have a SQL Server 2000 database(TRAK) on a Windows 2K box, and an Oracle database(PROD) on a Solaris box. I need to write a query... procedure... package... or something that will select the data I'm needing out of TRAK using criteria in PROD and update PROD. I have created a linked server to the PROD db on the SQL Server box. I am able to user Query Analyzer and select data out of the Oracle db (PROD). I guess my question is... What would be the best way, or any way, to accomplish this? thanks-doug-" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-07 : 10:57:37
|
| you are already using Linked Servers that is the best option AFAIK.--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
 |
|
|
|
|
|
Distributed Query and Import