Bulk Copy Program
 | The topic of this article may not meet Wikipedia's general notability guideline. (August 2009) |
 | This article needs additional citations for verification. (February 2008) |
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[2]
- DB2 uses the LOAD/EXPORT commands
- MySQL uses LOAD DATA INFILE.[3]
- PostgreSQL uses COPY command.[4]
References
- ^ "Microsoft SQL Server bcp Utility". Microsoft. April 2010.
- ^ http://docs.oracle.com/cd/B19306_01/server.102/b14220/utility.htm#sthref1799
- ^ "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. |