4 ms·
bcp and SqlBulkCopy are using the same underlying db mechanism.
by sams99 14y ago
bcp and SqlBulkCopy are using the same underlying db mechanism.
- koide 14y agoI read somewhere I cannot find right now that bcp is faster than SqlBulkCopy. My experience tends to match this, but that very well might be due to other factors (network, wrong coding, different default values between SqlBulkCopy and bcp.) Do you have a source to back your statement up? That way I could stop looking for mine :)
- sams99 14y agoI think funnily enough even though it is the same mechanism bcp is faster cause it is 100% native, I have seen native odbc outperform sqlclient by a factor of 2, would assume you would get the same for bulk operations. As always you are going to need to test. Now ... a hand coded c++ odbc implementation that uses the bulk insert services should be identical to bcp.