Jump to content

Bulk Copy Program

Add links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Yobot (talk | contribs) at 18:46, 4 May 2010 (Autotagging, removed expand tag using AWB). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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

References

  1. ^ "Microsoft SQL Server bcp Utility". Microsoft. April 2010.


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