| Oracle to SQL Server [message #8385] |
Thu, 14 August 2003 12:13  |
Seth Washeck
Messages: 1
Registered: August 2003
|
Junior Member |
|
|
|
I inherited a Microsoft SQL Server (6) that used to get data from an Oracle 8i. The person that created this used an Access macro to get the data from the Oracle DB. I was wondering if there was a (detailed) way to get the data directly into the SQL Server. Thanks for your help
|
|
|
|
| Re: Oracle to SQL Server [message #8386 is a reply to message #8385] |
Thu, 14 August 2003 12:30  |
Armani D
Messages: 19
Registered: February 2002
|
Junior Member |
|
|
|
Spool the data to a flat file, then use SQL server's bulk insert utility. Otherwise, you can use Oracle Transpartent Gateway for SQL Server.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
