Transfer Table from Oracle to SQL

  • Thread starter Thread starter -Steve-
  • Start date Start date
S

-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.
 
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
 
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!
***************************
 
Back
Top