Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy dbf structure to mySQL table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01534418
Message ID:
01534444
Views:
42
>Hi
>
>I've been working with PHP and mySQL for some time and I like it.
>I can manage my mySQL tables with VFP via ODBC.
>
>Now I installed mySQL in my desktop (localhost)
>
>Is there a way to copy structure of my .dbf file to a mySQL (localhost) table via ODBC ?
>
>Or do I have to create the structure manually ?
>
>The ideal was to create the structure with all data inside, but if I could only create the struture,
>I think I could be able to copy all via ODBC.
>
>
>Moises

I found a number of conversion programs a few years ago. Google VFP to MySQL and you will find a number of them. I wound up writing my own but it works with the data dictionary that we did on our own. If your serous about this then writing your own conversion program is a great way to learn about MySQL. By the way, I strongly suggest you stay away from ODBC and do everything in PHP on the server end.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform