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

Yeah, in my case there are too many corporate firewalls on both sides of the transfer. (One government agency, one large bank).

No way could I ever get through the paperwork to do a direct connection between the servers.

And the data quantities are generally fairly small (thousands of rows, not millions). So TDA works great, since I have client access to read the SQL*Server source and write to the Oracle target.

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of SCHROEDER, NATHAN E (AG/1000)
Sent: Friday, November 04, 2011 09:13 AM
To: [email protected]
Subject: RE: [toad] How to load data from an oracle database into a SQL server table


Personally I'm looking for a way to automate a data flow, but our idea of automation is to have the databases talk to each other, not to schedule something in Toad; so for my personal purposes adding something to Toad is not worth the effort.
Nate Schroeder
Enterprise Services - Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. LC4D - Saint Louis, MO - 63167
314-694-2592
From: [email protected] [mailto:[email protected]] On Behalf Of John Dorlon
Sent: Friday, November 04, 2011 9:11 AM
To: [email protected]
Subject: RE: [toad] 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.


This e-mail message may contain privileged and/or confidential information, and is intended to be received only by persons entitled
to receive such information. If you have received this e-mail in error, please notify the sender immediately. Please delete it and
all attachments from any servers, hard drives or any other media. Other use of this e-mail by you is strictly prohibited.

All e-mails and attachments sent and received are subject to monitoring, reading and archival by Monsanto, including its
subsidiaries. The recipient of this e-mail is solely responsible for checking for the presence of "Viruses" or other "Malware".
Monsanto, along with its subsidiaries, accepts no liability for any damage caused by any such code transmitted by or accompanying
this e-mail or any attachment.


The information contained in this email may be subject to the export control laws and regulations of the United States, potentially
including but not limited to the Export Administration Regulations (EAR) and sanctions regulations issued by the U.S. Department of
Treasury, Office of Foreign Asset Controls (OFAC).  As a recipient of this information you are obligated to comply with all
applicable U.S. export laws and regulations.