Convert Visual foxpro database to Mysql using PHP

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Pepe_Le_Pew
Forum Newbie
Posts: 6
Joined: Tue Jul 09, 2002 9:52 am
Location: Longueuil, Québec

Convert Visual foxpro database to Mysql using PHP

Post 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
User avatar
doomhunk
Forum Newbie
Posts: 2
Joined: Mon Sep 23, 2002 11:16 pm
Location: London & Essex, UK
Contact:

Post 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?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
User avatar
doomhunk
Forum Newbie
Posts: 2
Joined: Mon Sep 23, 2002 11:16 pm
Location: London & Essex, UK
Contact:

Post 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
Post Reply