Hi Al,
>anyone else had to do something similiar? If so, I'd be interested in hearing about the approach that you used.
Yeah, I wrote a program which takes a VFP DBC and Bulk inserts the data into the matching tables of a SQL database.
I havn't tested the alternatives, but according to what I've read, this is supposed to be the fastest method. It sure seems a LOT faster than DTS. Especially if the data is pre-sorted accoring to the clustered index, you set the Recovery mode to Bulk, and you drop the indexes before the insert and re-create them afterwords. The only problems I've run into is tables with memo fields. For those I use DTS.