Bulk Copy Program

Common Uses

• 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, implemented on the command-line as sqlldr
• DB2 uses the LOAD/EXPORT commands
• MySQL uses LOAD DATA INFILE
• PostgreSQL uses the COPY command