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