SqlBulkCopy and Oracle?

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.
 
E

Elton Wang

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)
 
E

Eric

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?

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
 
P

Pablo Castro [MS]

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.
 
B

Bradley Plett

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top