SQL Server DBA

Data movement, bulk operations, SQL Server Agent, and automation

Question

bcp versus BULK INSERT: how do their execution contexts and best uses differ?

Answer

bcp is a client utility that exports or imports through a client connection; BULK INSERT is a T-SQL statement executed by the Database Engine. Use bcp for command-line pipelines and exports; use BULK INSERT for server-side, database-controlled loads.

This is 4 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples