Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy dbf structure to mySQL table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01534418
Message ID:
01534444
Vues:
39
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform