Bulk Copy Program

Bulk Copy Program

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.

It has many switches that can be passed to alter its behavior.Switching end of line (EOL) characters as well as row terminators is trivial.More custom conversions are done using format files that define column re-mapping or skipping, for instance.The raw speed of BCP to get the data in quick is always nice, but more refined data operations are best served by database vendor specific code.

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.

If you have the bcp.exe executable installed on your computer, usage instructions can be received on the command-line with a help switch like so.

bcp /?


Wikimedia Foundation. 2010.

Игры ⚽ Нужно решить контрольную?

Look at other dictionaries:

  • Sony BMG CD copy prevention scandal — The Sony BMG CD copy prevention scandal concerns the copy prevention measures included by Sony BMG on compact discs in 2005. Sony BMG included the Extended Copy Protection (XCP) and MediaMax CD 3 software on music CDs. XCP was put on 52 titles [… …   Wikipedia

  • Brittle Books Program — The Brittle Books Program is an initiative carried out by the National Endowment for the Humanities at the request of the United States Congress. The initiative began officially between 1988 and 1989 and was to involve the eventual microfilming… …   Wikipedia

  • BCP — Best Current Practice (Business » General) Business Continuity Plan (Business » General) Best Current Practices (Governmental » NASA) **** Book Of Common Prayer (Community » Religion) ** Birth Control Pills (Medical » Physiology) ** Birth Control …   Abbreviations dictionary

  • FreeTDS — is a free software programming library, a re implementation of the Tabular Data Stream protocol. It can be used in place of Sybase s db lib or ct lib libraries. It also includes an ODBC library. It allows many open source applications such as… …   Wikipedia

  • Data Transformation Services — Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database. The objects are DTS packages and their components, and the utilities are called DTS… …   Wikipedia

  • BCP — may refer to: *Bathocuproine *Book of Common Prayer *Best Current Practice *Business continuity planning *Birth control pill, usually referring to the combined oral contraceptive pill *Bulk Copy Program *Bridge Control Protocol *Bugs Crawling Out …   Wikipedia

  • BCP (homonymie) — Cette page d’homonymie répertorie les différents sujets et articles partageant un même nom. Une BCP (de l’anglais best current practice, « meilleure pratique actuelle ») désigne une série de documents prénormatifs (publiés en tant que… …   Wikipédia en Français

  • BCP — • Best Current Practices (RFC Subseries) • Byte Control(led) Protocol(s) • Bureau of Consumers Protection • Binary Compatibility Package (unter Sun: Paket zur Benutzung von Solaris 1 Programmen unter Solaris 2 funktioniert leidert trotzdem nicht… …   Acronyms

  • BCP — [1] Best Current Practices (RFC Subseries) [2] Byte Control(led) Protocol(s) [3] Bureau of Consumers Protection [4] Binary Compatibility Package (unter Sun: Paket zur Benutzung von Solaris 1 Programmen unter Solaris 2 funktioniert leidert… …   Acronyms von A bis Z

  • BCP — abbr. (Internet) Best Current Practice (Internet, RFC) abbr. (PPP) Bridging Control Protocol (PPP, RFC 1638) abbr. Basic Call Process (IN) abbr. Binary Communications Protocol abbr. Binary Control Protocol (Adobe, PS) comp. abbr. Best Current… …   United dictionary of abbreviations and acronyms

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”