Faster inserts in DataAbstract via SqlBulkCopy

Data Abstract
1

I was just wondering if it is possible to tell DA to use BCP for inserts.

I have some tables where I insert a very large number of records in bulk (100k+)

This is done with an individual insert statement which is slower than BCP

Note: There is also a query (SELECT IsNull(@@identity,0)) that is done each time which I don’t need in this particular case. Can this be omitted.

2

Hi,

DAN uses IDbCommand interface for executing insert/update/delete commands and SqlBulkCopy isn’t supported by default.

You can try to implement this feature manually.

this query is declared in DataAbstract.daConfig. You can modify this file and declare own profile.

You can read more about .daConfig at