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 |
|
sach1
Starting Member
1 Post |
 Posted - 2002-08-22 : 08:23:47
|
| i have two questions.1. i have linked sql server 7.0 with oracle server. the queries run very slow and also the stored procedures. i am trying to retrieve data from oracle and populate my tables in sql server.how do i speed up the data extraction from oracle server. i don't have control on oracle server, as third party owns that server.i tried to use pass through queries but having syntax problem. is there any article i can read apart from BOL?2. Is it possible to run jobs on sql server which retrieve data from the oracle server? if possible, how can i do that.I would really appreciate your help with thses questions.thanks |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-08-22 : 09:25:33
|
| Make sure your connection to Oracle is through OLE DB, not ODBC as that will be faster. You should also work on getting pass-through queries to work as that will be the fastest.Yes, you can run jobs on sql that pull data from Oracle. Use OPENQUERY to do the pass-throughs. |
 |
|
|
|
|
|
sql server 7.0 and oracle (linked server) - urgent