Moving foxpro database to mysql database possible?

Question

hi I'm creating a windows service that will update a mysql database from foxpro database every one hour. My idea on doing this is to copy the foxpro database in a folder then I will convert or move it to the mysql database. But the problem is I don't know how to move or convert to mysql database. Any help please. Thanks in advance.

Answer 1

Why not just use the Foxpro db and skip going to all this bother? Change your connection string.



If you need a Enterprise type of DB like MS SQL or MySQL then you should really consider a re-write anyway. If this is for Windows then consider using MS SQL Express. You can use it on your server with multiple users and it's free.



You do know that using Fox can handle multiple users right?

Answer 2

You would be far better off using a cursor adapter in vfp and send cursor updates to your mysql server. This would be much more efficient and you would not have to copy anything to the server. You could also create realtime updates with this method.

Answer 3

http://www.convert-in.com/dbf2sql.htm (not free).