Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL updates and VFP table buffering
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00611778
Message ID:
00611860
Views:
31
Hi,

Already tried the DTS, but somehow I made a mistake and I only get a "Unknown error c:\temp\myxml.xml" error message whenever I right click on a table and select Export to XML.

I have VFP 7 but never heard of a VFP OLDDB provider. Any place/site document where I could learn more on this?

Thanks,
Arriyel

>>Hi,
>>
>>I need to upload data to the SQL table from VFP tables. Thing is the VFP tables do not have the same structures as the SQL table and some VFP tables splits up to more than one SQL table.
>>
>>I already have a translation/conversion program to get the data to the SQL database. Only problem is that the upload is slow (about 0.2 sec per record
>>and 10k to 50k records to upload).
>>
>>Is there a faster way of doing this. I tried using a remote view of the SQL tables with buffering set to 5 (table buffering) then adding all my records and then doing a tableupdate() but it would only add 10 records or less with the rest missing. Is there a setting on the SQL server I need to set?
>>
>>Any help would be greatly appreciated.
>>
>>TIA,
>>Arriyel
>
>You might be able to use the Data Transformation Services (DTS) that comes with SQL Server 7 and 2000. You can select what you want imported from your VFP source and select where you want to put the information into your SQL Server target.
>
>You will be using the VFP ODBC driver if using VFP 6, so it may be relatively slow. If using VFP 7, you can use the VFP OLDDB provider and the performance should increase.
>
>HTH.
Speak using soft and sweet words in case you have to eat them later.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform