Hi,
I have to come up with a solution that will be responsible for moving between 250,000 to over 10,000,000 records from a VFP table into a table in a SQL Server Database (or MSDE for the clients with lower volumes).
My initial thought was to write a little VB program to bring in about 1,000 records at a time, transform the data into the correct format, and insert into SQL Server using Bulk Insert - and keep repeating the process until all the records have been imported.
Has anyone else had to do something similiar? If so, I'd be interested in hearing about the approach that you used.
Regards,
Al
Al Williams
Anola MB, CANADA