Bulk Copy Program
This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these template messages)(Learn how and when to remove this template message)
Bulk Copy Program (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.
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.
- Oracle uses SQL*LOADER, implemented on the command-line as
- DB2 uses the LOAD/EXPORT commands
- MySQL uses LOAD DATA INFILE
- PostgreSQL uses the COPY command
- "Microsoft SQL Server bcp Utility". Microsoft. April 2010.
Gennick, Jonathan; Mishra, Sanjay (2001). Oracle SQL*Loader: The Definitive Guide. Definitive Guide Series. O'Reilly Media, Inc. p. 14. ISBN 9781565929487. Retrieved 2015-08-13.
On Unix systems, the command used to invoke SQL*Loader is sqlldr. On Windows systems running Oracle8i, release 8.1 or higher, the command is also sqlldr. Prior to release 8.1, the SQL*Loader command on Windows included the first two digits of the Oracle release number [...] sqlldr80 (Oracle8, release 8.0), sqlldr73 (Oracle7, release 7.3), and so forth.
- "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.|