RE: 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???!?



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/