SqlBulkCopy Tutorial - Knowledge Base (KB)

Bulk Copy from SQL Server to Oracle

I have a requirement for a project to move data from SQL Server to Oracle in bulk mode. There is OracleBulkCopy from DataDirect and ODP .net but to use that I have to first convert the data reader from SQL server into a CSV file and then can export that u...

Oracle ODP.NET BulkCopy to temporary table issue

I'm using BulkCopy method from ODP.NET to insert a DataTable to a temporary table. If the temporary table is simple (no triggers or indexes) it works, fine, but as soon as I create an index or trigger, i get the "End-of-file on communication channel" erro...

DBMS_SQL.Execute and BULK update - Need Help

I have this query...select col1, col2 from table where critera = :criteria_var...The particular query was being used in DBMS_SQL to open cursor and ...BIND... the variables. The values are then being fetched by DBMS_SQL functions which are then updating...

OracleBulkCopy AutoCommits

C#.Net I am using OracleBulkCopy to copy data to global temp tables that are declared as Delete on commit. So when I use OracleBulkCopy.WriteToServer(DataReader). It commits and I am losing all the data. How to prevent this?

What is the difference between giving BatchSize and not giving BatchSize for OracleBulkCopy

Can anybody give the performance & behavior difference between using ...BatchSize... and without using ...BatchSize... in ...OracleBulkCopy.... Currently I don't specify ...BatchSize.... My ...BatchSize... may vary from 100 to 200000. Please suggest the b...

Oracle BulkCopy Type Matching

I am using SSIS for table transfers between different DBs. Since it is not specific to one source and target, and SSIS does not have dynamic column mapping itself, I implemented a script on C# by utilizing the OracleBulkCopy and SqlBulkCopy for writing to...

OracleBulkCopy Memory Leak(OutOfMemory Exception)

Below is the code I used to bulkcopy data from a temp table dataTable into a destTable in Oracle Database. The dataTable has about 2 million records....using (OracleBulkCopy bulkCopy = new OracleBulkCopy(VMSDATAConnectionString)) { ...

How Transform OracleAdapter Dataset to SQL BulkCopy

I've successfully used the ...Oracle.ManagedDataAccess.Client... to fetch data from an Oracle server into a ...Dataset..., and used ...SqlBulkCopy... to insert that ...Dataset... into a SQL database where the tables have matching columns names (see below...

How to skip same duplicate key data when copy table

I have a table1(key is X, XX) looks like below:...x,y,xx,yy,xxx,yyy ...I created a new table2 (key is code) as below:...code,name,xx,yy,xxx,yyy ...Now I wan to copy all data in table1 to table2, and if met same code skip it, ...x -> code Y -> name xx-> xx...