The Bulk Copy Program is still a handy utility for transferring data in and out of tables in SQL. However, using it properly requires that you learn the various command line options. To obtain a complete list, simply type bcp /?. The important parameter -B specifies the batch size to be used. For example, take a situation where you are using BCP to load a table with a million records. If you don’t specify the batch size, the million records will be committed all at once. It is much faster and safer to specify a batch size of a thousand. This way, every thousand records are committed separately.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
