zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

9 results in tag: oracle

Bulk SQL Server to Oracle Copy

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 sqlbulkcopy sql-server
asked by Manav

Issue with Oracle ODP.NET BulkCopy to Temporary Table

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...
odp.net ora-03113 oracle sqlbulkcopy
asked by maephisto

Need assistance with DBMS SQL.Execute and BULK update

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...
oracle plsql sqlbulkcopy
asked by x.509

AutoCommits OracleBulkCopy

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?
c# odp.net oracle sqlbulkcopy
asked by Naveen Chakravarthy

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...
ado.net c# oracle sql sqlbulkcopy
asked by user1887523

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...
c# odp.net oracle sqlbulkcopy ssis
asked by stackoverflowthebest

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)) { ...
bulkinsert c# memory-leaks oracle sqlbulkcopy
asked by mhan0125

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...
dataset oracle oracle-manageddataaccess sqlbulkcopy vb.net
asked by Wowdude

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...
oracle sqlbulkcopy sql-insert subquery
asked by mikezang

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!