从MS Access移植 [英] Porting from MS Access

问题描述

我最近获得了一个MS Access .mdb数据库文件，并要求使其在Linux系统中可用.我正在寻找一种将Access数据库转换为开源数据库(例如MySQL或PostGres)的方法.

I've recently been given a MS Access .mdb database file and asked to make it usable in a Linux system. What I'm looking for is a way to convert the Access database to an open-source database such as MySQL or PostGres.

我没有MS Office，这是一个志愿者组织的一次性项目，因此，如果可以避免的话，我不想花钱.我运行的是Vista x64，并且具有Linux虚拟机，因此在其中任何一个中可用的东西都会很好.

I don't have MS Office, and it's a one-time project for a volunteer organization so I don't want to spend money if it's avoidable. I'm running Vista x64, and have a Linux virtualbox, so something usable in either one will be good.

推荐答案

我使用了

I used the MySQL Migration Toolkit and it worked very well for tables, even creating a reusable script. It is free and simple to use.

此工具包现已停产，并且 MySQL Workbench 5.2 取代了它.

This toolkit is now EOL and the MySQL Workbench 5.2 replaces it.

不幸的是，当我在系统上使用MS Access尝试时，出现问题导致程序无法正常运行"的故障.当然，在最后一步. (2013年1月16日)

Unfortunately, it falls over with "A problem caused the program to stop working correctly" when I try it with MS Access on my system. At the last step, of course. (Jan 16 2013)

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