How to integrate Visual FoxPro w/ MySQL for eCommerce website?

distro_dave

I'm working on an eCommerce website for a small merchant. This merchant uses Opera (which is based on Visual FoxPro) to manage his in-store inventory, and would like the online store inventory to reflect the in-store inventory. I'm guessing that my first step is to set up a way to regularly transfer the information from the VFP database to a MySQL database on the website's server. Is there an established process for this? Am I even approaching...

Originally asked by Jack on Stack Exchange (stackoverflow) (CC BY-SA 2.5).

uphilltech

Great question — answering as the UphillTech team:

Co-worker developed synchronization process between VFP and MSSQL2008. WCF service which took input directly from VFP. On other project - as far as i remember, when we tried ODBC .NET data adapter, it had problems with encodings and foreign languages. That's why we used COM+, serialization for communication with .NET. But it seems to me you are using PHP (eCommerce=>Drupal=>PHP) so you are in completely different situation. In your case, i would start with checking out if Opera (i guess it's this Opera ) provides built-in export and eCommerce provides built-in import. Mostly because it might be tedious work to sync data manually from 2 apps coded by someone else. Then i would research if...

Full answer by user82062: https://stackoverflow.stackexchange.com/a/2052040 (CC BY-SA 2.5).

Need it done for your business? UphillTech.