Jump to content

Bulk Copy Program

Add links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Tustin2121 (talk | contribs) at 18:03, 13 August 2009 (Removed opinionated descriptions and usless facts. Added --expand--. Copied --unref-- to bottom, since nothing is there.). 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 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.

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=307784205"