Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

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.

 

 

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