Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Enterprise
Expertise: All
Apr 20, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

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.
Joseph Lax
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date