Over the last 10 years or so I’ve been responsible for the import of many hundreds of millions of records into production SQL Server databases. The fastest and most reliable way I found to achieve this is using the ODBC Bulk Copy API. But it’s not the easiest thing to do in C#. In fact, C# code for this purpose is surprisingly rare.

Wanting a complete tool that I could easily share with clients and colleagues, I decided to create SqlBulkCopy. It is very fast and comprehensively tested. Special thanks to Jolin Qiao, SQL Server Professional Support Engineer at Microsoft, who got me answers for some pretty tough questions.

In my experience, nothing is easier to use, quicker to set up, or more reliable. I hope you find it useful. You can find the source code on GitHub or install using nuget.

Regards,

Brett Werner

January 2015