Jump to content

Bulk Copy Program

Add links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Kalotus (talk | contribs) at 14:13, 9 October 2009. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Bulk Copy Program (BCP) is a command-line tool used to import or export data against a Microsoft SQL Server 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.

References

Stub icon

This database software-related article is a stub. You can help Wikipedia by expanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=Bulk_Copy_Program&oldid=318870707"