RE: How to load data from an oracle database into a SQL server table

How big of a deal is this kind of thing - moving data between Oracle and SQL Server?

It probably wouldn't be that tough to use ODBC as a destination for grid->rt-click->Export DataSet, or as a source for "Import Table Data".

The only downside to that is I'd have to use ODBC, which gives me the heeby-jeebies.

-John


From: [email protected] [mailto:[email protected]] On Behalf Of Rich Jesse
Sent: Thursday, November 03, 2011 8:54 PM
To: [email protected]
Subject: RE: [toad] How to load data from an oracle database into a SQL server table



Hey Nate,

> For option 1, do you need some Oracle gateway product on the Oracle server
> to make that work?
>
> From: Stephen Miller
> Sent: Thursday, November 03, 2011 3:17 PM
> Subject: Re: [toad] How to load data from an oracle database into a SQL
> server table
>
> You can do it one of two ways:
>
> 1. Set up a DATABASE LINK in ORACLE that connects to SQL SERVER, and then
> push the data to SQL SERVER
>
> 2. Set up a Linked Server in SQL Server, and pull the data from ORACLE.
>
> Only option 1 can be done from within TOAD.

There are a few ways to do that w/o the expensive Oracle Gateway. I haven't
used this, but:

http://www.easysoft.com/applications/oracle/database-gateway-dg4odbc.html

...is free after registering.

Personally, I'd push/pull from SQL Server, if possible. Actually, that's
exactly what I do, using Toad for SS to set it up.

GL!

Rich -- [TeamT]

Disclaimer: I fervently deny any and all allegations of SQL misconduct upon me.