Search code examples
javamysqljdbcfoxpro

How to migrate data from FoxPro to MySQL

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?
Solution

  • 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