Jump to content

Bulk Copy Program

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by 217.117.64.234 (talk) at 14:50, 17 October 2011 (→Other Platforms). 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)

The topic of this article may not meet Wikipedia's general notability guideline. Please help to demonstrate the notability of the topic by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond a mere trivial mention. If notability cannot be shown, the article is likely to be merged, redirected, or deleted.
Find sources: "Bulk Copy Program" – news · newspapers · books · scholar · JSTOR (August 2009) (Learn how and when to remove this message)

This article needs additional citations for verification. 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 ^{[citation needed]} 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/EXPORT commands.
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=456015309"

Hidden categories: