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 |
|
yipchunyu
Yak Posting Veteran
80 Posts |
 Posted - 2007-05-21 : 23:33:24
|
| I would like to import data from an Oracle 10G server.What it the best option to do so to some complex logic in selecing?1. Import data to SQL and use the SP to transform the data2. Call a PLSQL directly from SQL Server and import these data directly?3. Any other options.BTW, what is the fastest driver to import data from Oracle?Thx for your attenion. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-21 : 23:54:16
|
| I'll go to option 1 if dataset is not too big. I tried odbc provider and oracle oledb provider in linked server, didn't see big difference in speed but odbc is more stable. |
 |
|
|
|
|
|
Import data from Oracle