>
>1. Is there a reasonably convenient way to "plug in" to SQL databases >2. What is the fastest way to push data into SQL server via VFP? I tried it once with a view and tablebuffering set on. Appended 10,000 records in a flash. Then I said "Tableupdate()", and near-paralysis set in on my machine. I have not yet tried using SQL pass through with pre-constructed INSERT INTO statements. Anybody had experience with this?
>
>BTW: The databases I deal with are 100-500 megs in size so there is lots of data to move around.
I think the fastest way for simple batch appending is to have temporary empty table with the same structure as existing one and:
1. Append records into remote view based on empty table.
2. Tableupdate this view to move data to SQL.
3. Call SQL stored procedure (using pass-through) to append temp table to permanent one.
Also it can be helpful to use asynchronous connection not to stop user.
Edward Pikman
Independent Consultant