Using the Bulk Copy Program Properly

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: