Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server: Getting data in.
Message
From
27/12/1996 09:18:32
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00016041
Message ID:
00016054
Views:
30
>
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform