同步Access DB和MySQL [英] Synchronizing Access DB and MySQL

问题描述

我有一个使用Access拥有非常大内部系统的客户，该系统在内部用于处理几乎所有公司数据.他们想要该数据库中客户数据的Web前端，并且将在其他服务器上运行.鉴于Access的限制，前端可能会使用MySQL.

I've got a client who has a very large internal system using Access, which is used internally to handle virtually all company data. They want a web front-end to the customer data in that database, and would be running on a different server. Given the limitations on Access, the front-end would likely use MySQL.

剩下的问题是同步数据.不需要秒，甚至每天都可以，但是我真的不确定这样做的好方法.

Which leaves the issue of synchronizing the data. It doesn't need to be to-the-second, even daily would be fine, but I'm really unsure of a good means of doing this.

鉴于现有系统的范围，将整个系统移至另一个数据库(例如MySQL)将花费不成比例的时间，并且工作量很大.

Given the scope of the existing system, it would be a disproportionate amount of time and work to move the entire system to another database such as MySQL.

有什么实际的方法可以做到这一点?

Is there any practical way to accomplish this?

推荐答案

我将让一位经验丰富的Access开发人员扩大Access应用程序，以使用SQL Server Express代替MySQL来获取数据.我会选择SQL Server Express而不是MySQL，因为它很可能与Access更好地工作，并且您可能会发现失去了对MS Access和SQL Server组合的在线支持，而失去了对MS Access和MySQL的支持.

I would get an experienced Access developer to upsize the Access application to use SQL Server Express for the data instead of MySQL. I would choose SQL Server Express over MySQL is it is very likely to work better with Access and you'll likely find a lost more online support for the combination of MS Access and SQL Server than you would for MS Access and MySQL.

对于一个有经验的人，这项工作可能要花几个星期或更长时间.当然，系统越大，所需的时间就越长.

This work can take several weeks or more for an experienced person. And of course the larger the system the longer this will take.

一个因素是客户是否希望数据从网站下载到数据库或只是将数据发布到Web?如果只是发布到Web，则使用查询更新Web数据库的建议可能会起作用.如果这两种方式都使事情变得更加棘手，并且将来将其升级到SQL Server将是一个更好的选择.

One factor is if the client wants data to come down from the website to the database or just publish data to the web? If just publishing to the web then the suggestion of updating the web database using queries could work. If both ways then things start to get trickier and upsizing to SQL Server for the future would be a better option.

这篇关于同步Access DB和MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！