如何将 Visual FoxPro 与 MySQL 集成用于电子商务网站？
我正在为一家小商家开发一个电子商务网站。该商家使用 Opera（基于 Visual FoxPro）来管理其店内库存，并希望在线商店库存反映店内库存。
我猜我的第一步是建立一种方法来定期将信息从 VFP 数据库传输到网站服务器上的 MySQL 数据库。是否有一个既定的流程？我是否从正确的角度来处理这个问题？我听说过很多有关 ODBC 的内容，但不确定如何实现它，或者不确定它是否是我在这种情况下所寻找的。
如果到目前为止还不是很明显，那么我就有点不知所措了，并且非常感谢您提供的任何和所有建议，包括文章或教程的链接，这些链接可以帮助提高我对这里所有移动部件的总体理解。
非常感谢。
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 this problem from the right angle? I've heard a lot about ODBC, but am unsure as to how to implement it or if it's what I'm looking for in this situation.
If it wasn't obvious by this point, I'm in over my head here, and would appreciate any and all advice you may have, including links to articles or tutorials that can help improve my general understanding of all the moving parts here.
Thanks much.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
同事开发了VFP和MSSQL2008之间的同步程序。 WCF 服务直接从 VFP 获取输入。
在其他项目中 - 据我记得，当我们尝试 ODBC .NET 数据适配器时，它存在编码和外语问题。这就是我们使用 COM+ 序列化与 .NET 通信的原因。
但在我看来，您正在使用 PHP (eCommerce=>Drupal=>PHP)，所以您处于完全不同的情况。
在你的情况下，我会首先检查 Opera 是否（我猜它是 此 Opera) 提供内置导出，电子商务提供内置导入。主要是因为从其他人编码的 2 个应用程序手动同步数据可能是一项乏味的工作。然后我会研究是否可以加入 i/o 并实现自动化（类似于 win 环境上的计划任务）。不幸的是，我无法提供更多帮助，因为我不熟悉这些工具、产品和技术。
不管怎样——在我看来，这是一项相当艰巨和肮脏的任务，祝你好运。 :)
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 i/o can be joined and automated (something like scheduled task on win environment). Unfortunately, can't help much more because i'm unfamiliar with those tools, products and technologies.
Anyway - it seems to me like quite hard and dirty task and i wish you good luck. :)
取决于您用来实现网站的内容。一般来说，使用 ODBC 非常容易（在 Java 中，我使用 jdbc-odbc 桥来实现）
Depend on what is that you are using to implement the website.. in general it is pretty easy with ODBC (In Java , I did it using the jdbc-odbc bridge)