Mysql and Foxpro

[wijbenga]

Hello there everyone,

Here's my story, i already tried to post this on a dutch forum but noone seem to have the awnsers.

Here at my work we have an intranet, but also a heldeskmanagement tool, this tool uses foxpro to store all its data. In this tool we have entered a lot of standard solutions, wich is quite grand but doesnt quite forfill its needs if only the people who have got the (overpriced) tool installed on there desktop. Wich made me think, hey cant we export/import this to the intranet.

I was already working with php and mysql before i even came up with this idea and i figured that mysql and php can do a lot together, so why not this?
I searched a while and ran into an extension of mysql; MYodbc, grand! Im able to import databases other then mysql into mysql!
But how? I searched, and i searched, but found none. (Except for some accesdb's into mysql) But thats not what i needed, i need to import a foxpro database into the mysql database of my intranet so i can make the information we store available for everyone!

So now you all know what i want to achieve, please brainstorm some with me

Ok, this is what i think i should do, and please, correct me if im wrong.

Ive got 2 servers, server A is the intranet server, and server B is the server were the Foxpro databases runs at.

On server A ive installed mysql, php and myodbc.
On server B ive installed the foxpro database, wich has its connections in ODBC ( not myodbc ) and there sitting there with the 2 of them, 1 called foxpro databases, the other called foxpro tables.

Now what i need to do is connect the 2 odbc's with eachother? Need i install myodbc on server B or can i just connect MYodbc with the odbc installed on server B?

And how the hell do i do this? And how do i make sure that every time there is entered something on one of the databases ( either server a or b ) its synchronized?

Im quite new to handling other dbases then mysql so any help and guidance is verry much apreciated.

Thanx in advance! BBYE

[edwardsbc]

It sounds like you are on the right track. Once you are able to make your PHP server connect to both databases you can fairly easily take the data out of FoxPro and put it into MySQL (or what ever).

Please understand the fundamental differences between FoxPro and MySQL so you don't get surprised. FoxPro is a ROW-based database management system. MySQL (and most other RDBMS) are SET-based. You will find there are things that were trivial to accomplish in FoxPro that are (ralatively) difficult in MySQL. Of course, the opposite is true too.

I have converted a couple of FoxPro databases to M$ SQL. Usually it is best to go through the FoxPro table row by row and check and make sure all of the values are compatible or converted to valid SQL types. It is also usually necessary to add a autonumber/primary key to the table (FoxPro always had row numbers).