Hint:
To avoid an overflow of your transaction log while using the bcp command option
(available in Sybase and SQL servers), select the "batch mode" by using the
command option: -b number of rows.  For example, the command option -b 10000 will
cause a commit to the table every 10,000 rows.

From: Chapter 5, The Single Nucleotide Polymorphism Database (dbSNP) of Nucleotide Sequence Variation

Cover of The NCBI Handbook
The NCBI Handbook [Internet].
McEntyre J, Ostell J, editors.
Copyright Notice

NCBI Bookshelf. A service of the National Library of Medicine, National Institutes of Health.