photo src: i.ytimg.com
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.
Video Bulk Copy Program
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.
Maps Bulk Copy Program
Other platforms
- Oracle uses SQL*LOADER, implemented on the command-line as
sqlldr - DB2 uses the LOAD/EXPORT commands
- MySQL uses LOAD DATA INFILE
- PostgreSQL uses the COPY command
photo src: images.slideplayer.com
References
Source of the article : Wikipedia
0 Comments