locked
Foxpro data transfer to mysql RRS feed

  • Question

  • Hi all,

    It would be great if some one can help me to transfer the foxpro data to mysql. Also how to take the backup of the foxpro database and what are the steps to be needed.

    Thanks in advance

    Ansu

    • Changed type Pavel Celba Tuesday, September 25, 2012 8:32 PM
    Monday, September 24, 2012 1:25 PM

Answers

  • Tuesday, September 25, 2012 6:26 PM
  • This book could help: http://www.hentzenwerke.com/catalog/mysqlvfp.htm

    The FoxPro backup is very simple operation: Copy all files to your backup media. You should include the whole data folder. If you ZIP the output then you may save about 90% of space.

    You should also backup the application processing these data.

    Tuesday, September 25, 2012 8:32 PM
  • From your question it's clear, that you have a foxpro database and a mysql server/database. It's unclear what language you have at hand for transfer of data. As your goal is MySQL that would typically involve PHP. On windows you can use the win32 COM module and use the VFP OLEDB Provider to query foxpro data and of course then also insert it into MySQL. I'll spare you any code samples, until you made clear what you want to use.

    Pavel is right about the vfp backup. That doesn't depend on anything more than the data files, DBF,CDX,FPT, eventuall IDX. Also  DBC, DCT,DCX, typically all files inside a database folder.

    Now tell us what programming language you want to use to transfer data, MySQL has SQL, but no engine of MySQL is able to read DBFs, so you need something external. Tools like DBConvert mentioned by DMSoft may already be sufficient.

    Bye, Olaf.



    Tuesday, September 25, 2012 9:18 PM

All replies

  • Tuesday, September 25, 2012 6:26 PM
  • This book could help: http://www.hentzenwerke.com/catalog/mysqlvfp.htm

    The FoxPro backup is very simple operation: Copy all files to your backup media. You should include the whole data folder. If you ZIP the output then you may save about 90% of space.

    You should also backup the application processing these data.

    Tuesday, September 25, 2012 8:32 PM
  • From your question it's clear, that you have a foxpro database and a mysql server/database. It's unclear what language you have at hand for transfer of data. As your goal is MySQL that would typically involve PHP. On windows you can use the win32 COM module and use the VFP OLEDB Provider to query foxpro data and of course then also insert it into MySQL. I'll spare you any code samples, until you made clear what you want to use.

    Pavel is right about the vfp backup. That doesn't depend on anything more than the data files, DBF,CDX,FPT, eventuall IDX. Also  DBC, DCT,DCX, typically all files inside a database folder.

    Now tell us what programming language you want to use to transfer data, MySQL has SQL, but no engine of MySQL is able to read DBFs, so you need something external. Tools like DBConvert mentioned by DMSoft may already be sufficient.

    Bye, Olaf.



    Tuesday, September 25, 2012 9:18 PM