Using bcp to Transfer Data to and from SAP ASE

This chapter discusses the bcp bulk copy utility, which provides a convenient, high-speed method for transferring data between a database table or view and an operating system file.

bcp can read or write files in a wide variety of formats. When copying in from a file, bcp inserts data into an existing database table; when copying out to a file, bcp overwrites any previous contents of the file.

Versions earlier than 15.0.3 did not allow you to run fast bcp on tables with nonclustered indexes or triggers. Cluster Edition version 15.0.3 and later removes this restriction.

Related reference