Bulk Copy Program
Appearance
An editor has determined that sufficient sources exist to establish the subject's notability. (August 2009) |
Bulk Copy Program (BCP) is a command-line tool used to import or export data from a Structured Query Language (SQL) Database. The tool is often more efficient than more recent GUI-based applications, such as DTS, to import and extract data.
Common Uses
Some common uses of BCP are:
- Stage a raw text file in a table for further data scrubbing.
- Create a delimited or fixed-width file for exchange with another party.
- Backup data from a database vendor specific format, to a common text format.