Up Prev Next
From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: BCP'ing out
Date: Nov 7 1997 9:15PM
Michael Peppler wrote:
> email@example.com wrote:
> > Anyone have any sample code to get data from a table into a text file
> > (bcp out) using DB_OUT? I have used DB_IN extensively, but I cannot
> > find sufficient resources on how to do the opposite. I already wrote
> > a makeshift bcp out by polling the table and outputting to a text file
> > but it tends to be very slow.
> To bcp OUT you're probably better off using bcp, unless you need
> to bcp certain rows only (based on some criterion) in which
> case doing a select is exactly as fast as a bcp out.
BTW - the new 2.08_51 release should help for speed for this sort
Michael Peppler -||- Data Migrations Inc.
firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler