Moving Data in SQL Server: BULK INSERT, bcp, OPENROWSET, BACPAC Export/Import and Copying Databases
MAXERRORS in BULK INSERT doesn't skip every error: a single CSV row with the wrong column count stopped a 200,000-row load at zero. The file path resolved on the server, CODEPAGE not supported on Linux, the CR stuck to the last column of a CRLF file, staging and validation, log down from 43 MB to 0.5 MB with BULK_LOGGED and TABLOCK, OPENROWSET and bcp, and BACPAC export/import with SqlPackage from an anonymized copy.
15 Nov 2026
·
14 min
·
12
