This app was primarily intented to move dBase III and IV files into and out of SQL Server using Trusted Security (Windows Authentication).

You are currently limited to transferring a maximum of 2GB either from or to a DBF.

When transferring a DBF to SQL, the ODBCReader will read 1000 records at a time into a batch and then use the SQLBulkCopy function to transfer the data into SQL. When transferring a SQL table to a DBF, records are read fast enough that it reads and writes 1 record at a time. I do this to avoid OutOfMemory exceptions and other memory issues.

Last edited Mar 5, 2010 at 12:35 PM by madrowler, version 2


No comments yet.