Jump to content

Bulk Copy Program

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Agujero Negro (talk | contribs) at 17:01, 31 May 2010. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

An editor has determined that sufficient sources exist to establish the subject's notability. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.
Find sources: "Bulk Copy Program" – news · newspapers · books · scholar · JSTOR (August 2009) (Learn how and when to remove this message)

This article does not cite any sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.
Find sources: "Bulk Copy Program" – news · newspapers · books · scholar · JSTOR (February 2008) (Learn how and when to remove this message)

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

Other Platforms

Oracle uses SQL*LOADER.
DB2 uses the LOAD command.
MySQL uses LOAD DATA INFILE.^[2]
PostgreSQL uses COPY command.^[3]

References

^ "Microsoft SQL Server bcp Utility". Microsoft. April 2010.
^ "MySQL 5.1 LOAD DATA INFILE Documentation". Retrieved 2010-05-31.
^ "PostgreSQL 8.1.21 Documentation". Retrieved 2010-05-31.

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

Hidden categories: