How to migrate data from FoxPro to MySQL

Question

I am having a database in .dbf (FoxPro) format.

1. How to retrieve data from FoxPro using Java?
2. If the data can be migrated to MySQL, How to do the conversion?

Answer 1

Taking the data to intermediate formats seems flawed as there are limitation with memo fields and CSV or Excel files.

If you are interested in a more direct approach you could consider something like "VFP2MySQL Data Upload program" or "Stru2MySQL_2", both written by Visual FoxPro developers. Search for them on this download page:

http://leafe.com/dls/vfp

DB-Convert (http://dbconvert.com/convert-foxpro-to-mysql-sync.php) is a commercial product that you might find helpful.

Rick Schummer, VFP MVP