请输入您要查询的百科知识:

 

词条 Bulk Copy Program
释义

  1. Common Uses

  2. Other platforms

  3. References

{{multiple issues|{{notability|date=August 2009}}{{refimprove|date=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|date=April 2011}} 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 SQLLOADER,[2] implemented on the command-line as sqlldr[3]
  • DB2 uses the LOAD/EXPORT commands
  • MySQL uses LOAD DATA INFILE[4]
  • PostgreSQL uses the COPY command[5]

References

1. ^{{cite web|url=http://msdn.microsoft.com/en-us/library/ms162802.aspx|title=Microsoft SQL Server bcp Utility|publisher=Microsoft|date=April 2010}}
2. ^http://docs.oracle.com/cd/B19306_01/server.102/b14220/utility.htm#sthref1799
3. ^{{cite book| last1 = Gennick| first1 = Jonathan| last2 = Mishra| first2 = Sanjay| title = Oracle SQL*Loader: The Definitive Guide| url = https://books.google.com/books?id=61JoPm_qpkgC| series = Definitive Guide Series| publisher = O'Reilly Media, Inc.| publication-date = 2001| page = 14| isbn = 9781565929487| accessdate = 2015-08-13| quote = 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.}}
4. ^{{cite web |url = http://dev.mysql.com/doc/refman/5.1/en/load-data.html |title = MySQL 5.1 LOAD DATA INFILE Documentation |accessdate = 2010-05-31 }}
5. ^{{cite web |url = http://www.postgresql.org/docs/8.1/static/sql-copy.html |title = PostgreSQL 8.1.21 Documentation |accessdate = 2010-05-31 }}
{{database-software-stub}}

2 : Database administration tools|Microsoft database software

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/11/12 0:41:43