Transfer Table from Oracle to SQL

[-Steve-]

I have a table in Oracle that I want to transfer directly to SQL. What's
the best way of doing this? I don't really want to use a DTS package, and
would rather use ADO.net.

 

[W.G. Ryan MVP]

ADO.NET is not architected as a Data Transfer techonlogy although it will
work. Anyway, to do this, have two data adapters, one for the Sql Server
and one for the Oracle db. Set AcceptChangesDuringFill property of the Sql
Server adapter to false. Then fill the dataset. Immediately thereafter,
call update on the Oracle adatper using hte exact same dataset. This
article is Sql Server to Sql Server but the identical logic applies to
Oracle http://www.knowdotnet.com/articles/datasetmerge.html

 

[Guest]

One option. Pull data into DataSet. Create a DataSet from the table you wish
to populate. Copy the new information from the Oracle DataSet to the SQL
DataSet (table(s)). Issue an Update.

I am still more fond of DTS for this, as that is what it does well.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************