Summary
As you have seen in this chapter, it is fairly easy to create and implement a typical data export or data import from one datasource to another using either BCP or DTS. We have shown you how to bulk load data into and out of SQL Server using the BCP utility and just bulk load data into SQL Server using the BULK INSERT statement. The multitude of switches BCP offers is very comprehensive and addresses most, if not all, importing and exporting situations. More important, with the advent of some additional switches like ORDER (within hints), TABLOCK (within hints), batches (-b), network packet sizes (-a), and others, it is significantly easier to increase the performance of BCP in a big way. BCP has been around for a long time, and it will ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
