Hi!

I used converting VFP DBF file content into set of TXT files and exporting TXT files into SQL Server using bulk copying utility (BCP.EXE). If needed, I can help you in this. The VFP part algorithm - converting of VFP DBF file into TXT file sutable for exporting to SQL Server by BCP utility - is in the download File#9986. Contact me if you will have any problems in using it.

Using this approach, I was able to export 1 GB DBF table to SQL Server within 3 hours on my sluggish developer's machines.


>Hello all,
>
>I have to find a solution to transfer huge amount of records (about 20 millions - 200 bytes per record) from VFP to SQL SERVER due to VFP limitation of 2GB per table.
>
>The technology I tried up to now, is the Remote Views (SQL Exec) using ODBC connection but it seems very slow.
>
>Note : I wasn't test the tranfer time to SQL server up to now (I am planning to buy SQL Server very soon), but I test the same senario by passing records in MS ACCESS. For 10000 Records took me 1 minute !
>
>Questions :
>===========
>1. What Is the Average transfer time between VFP/SQL SERVER for 20 million Records ?
>
>2. There is any other way or technology to transfer huge amount of records from VFP to SQL Server?
>
>Thanks in advance
>Peter