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

Yeah there are ways around it.  Just wondering how common it is, and would it be worth the convenience of having it in Toad, where you can set it up as an action, etc.

From: [email protected] [mailto:[email protected]] On Behalf Of Rich Jesse
Sent: Friday, November 04, 2011 9:06 AM
To: [email protected]
Subject: RE: [toad] How to load data from an oracle database into a SQL server table



Hey John,

> 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.

And it should, although MS themselves have said that it's the future of DB
connectivity, even making an SQueaL Server ODBC driver on Linux.

That being said, if I do have a need for a 1-time data transfer like this, I
turn to Toad for Data Analysts. Since it's included with Toad for Oracle,
it would seem somewhat redundant, no?

My $.02,
Rich -- [TeamT]

Disclaimer: Are you not entertained???!?