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: The Database of Short Genetic Variation (dbSNP)

Cover of The NCBI Handbook
The NCBI Handbook [Internet]. 2nd edition.
Copyright Notice

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