Microsoft SQL Loading Large Dataset

fastest way to get it all in if it's really big

2022-03-13 14:21:43

microsoft-sql-loading-large-dataset

Jase has blogged:


Lately I’ve been loading large datasets into Microsoft SQL (MSSQL) and found the quickest way to do so is using BULK INSERT, even from .NET (instead of SqlBulkCopy for example). Chatting to people, it seems not many knew you could load data straight into MSSQL from a file using this, so I thought I’d write it up.


Read the full article