SqlBulkCopy and Oracle?

  • Thread starter Thread starter Bradley Plett
  • Start date Start date
B

Bradley Plett

I have read a little about the new SqlBulkCopy in ADO.NET 2.0. It
sounds like it's exactly what I need. However... is there an
equivalent for Oracle?

What I'm looking for is the fastest way to get 100,000+ records into
an Oracle database from a dataset. I'm very open to suggestions.
Presently we are looking at exporting from the dataset to a CSV and
then doing an external table mount from Oracle. Are there any better
ways?

Thanks!
Brad.
 
In Sql-server, there are bcp utilities to accommodate
insert multi-rows data from data file into database. So
even in ADO.NET 1.1 without SqlBulkCopy class, we are
using StringBuilder to create data file, then use Bulk
Insert to save data into the database. Compare to looping
though each row insert, it's much faster. I suppose in
Oracle, there are similar utilities to accommodate bulk
insert.

Elton Wang
(e-mail address removed)
 
Hello Bradley,
I have read a little about the new SqlBulkCopy in ADO.NET 2.0. It
sounds like it's exactly what I need. However... is there an
equivalent for Oracle?
Click to expand...

I've been told it will be in the new Oracle provider also. Microsoft and Oracle are working on it together.

Oracle will also be able to host the CLR in 10g Release 2. It should be possible to write a stored proc in C# or VB.NET.

Eric
 
SqlBulkCopy will be included in ADO.NET 2.0, in the .NET Provider for SQL
Server (aka SqlClient). We will not support bulk-copy in our OracleClient
provider that will ship with ADO.NET 2.0. I don't know whether Oracle's own
driver or 3rd party drivers support this.

--
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

This posting is provided "AS IS" with no warranties, and confers no rights.
 
So I take it that the rumours that "it will be in the new Oracle
provider also" and that "Microsoft and Oracle are working on it
together" mentioned below are hereby refuted? Oh, well, that did seem
a little too good to be true. :-S

Brad.
 
Back
Top