BCP Utility in SQL Server

This topic provides an overview for using the bcp utility to export data from anywhere in a SQL Server database where a SELECT statement works, including partitioned views.

The bcp utility (Bcp.exe) is a command-line tool that uses the Bulk Copy Program (BCP) API. The bcp utility performs the following tasks:

• Bulk exports data from a SQL Server table into a data file.
• Bulk exports data from a query.
• Bulk imports data from a data file into a SQL Server table.
• Generates format files.