O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding BCP

BULK COPY (BCP) offers a command-line alternative to the SQL Server Import And Export Wizard. The Transact-SQL counterpart to BCP import is BULK INSERT. You will find that BULK INSERT has a similar syntax when used for importing data. To learn more about BCP, we will examine its features:

  • Basics

  • Syntax

  • Permissions

  • Modes

  • Importing data

  • Exporting data

BCP Basics

BCP may continue to be a favorite of database administrators because of its great performance and minimal overhead. You will find that import and export processes tend to be very fast and that BCP requires very little memory to operate. BCP does not have a graphical user interface (GUI) and is best used in two situations:

  • To import data from a text file to a single SQL Server table ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required