Page 1 of 1

Convert Visual foxpro database to Mysql using PHP

Posted: Sun Jul 28, 2002 12:26 pm
by Pepe_Le_Pew
Hi everyone,

I need to convert a Visual foxpro database to mysql using PHP.

Do someone know's how to access foxpro tables structure that way ?

I have ODBC properly configured on WinXP

I do know how to create and populate the mysql database using PHP, but I'm stuck with foxpro.

any idea would be highly appreciated

thank's

Posted: Mon Sep 23, 2002 11:16 pm
by doomhunk
Bump!

I'd be interested to know this too, as I've just inherited a Visual Fox Pro 98 database and I'm trying to convert it to MySQL using PHP. So far I haven't been able to. As I'm dealing with 30 constantly updating tables I didn't want to have to dump them all to delimited text files & brute force them in. The manuals don't have any mention of how to do this or what file types are involved. Anyone know?

Posted: Tue Sep 24, 2002 4:47 am
by twigletmac
Have you tried using the MyODBC drivers to connect the two databases using ODBC? In the docs it says that MyODBC has been tested with FoxPro.

http://www.mysql.com/products/myodbc/fa ... plications
http://www.mysql.com/downloads/api-myodbc-2.50.html

Mac

Posted: Tue Sep 24, 2002 7:58 pm
by doomhunk
Thanks Mac, I don't know why my searches didn't turn that up, so thanks for the pointer.

Paul
doomhunk@aol.com