MS Access to Oracle 轻松转换/迁移
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2040781/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MS Access to Oracle easy Conversion / Migration
提问by Filip Ekberg
Are there any good easy to use softwares to export Access Database files to an Oracle 11g database?
有没有什么好用的软件可以把Access数据库文件导出到Oracle 11g数据库？
I know that this might not be the most usual case but applications grow, especially with old applications that uses old technologies such as Access in this case needs to be upgraded at some point.
我知道这可能不是最常见的情况，但应用程序会增长，尤其是使用旧技术（例如 Access）的旧应用程序在这种情况下需要在某个时候升级。
Tutorials and articles regarding Access 2003 and 2007 migrations would be preffered.
最好提供有关 Access 2003 和 2007 迁移的教程和文章。
There is a tool called mdbtools which would help by doing something like this:
有一个名为 mdbtools 的工具可以通过执行以下操作来提供帮助：
for i in *.mdb;do mdb-schema $i oracle > $i.schema.sql;done
However I am on a Windows enviornment and mdbtools seems to be a Linux-only tool.
但是我在 Windows 环境中，mdbtools 似乎是一个仅限 Linux 的工具。
采纳答案by APC
The Migration Workbench which comes with Oracle's (free) SQL Developer tool supports migrating from MS Access. Find out more.
Oracle 的（免费）SQL Developer 工具附带的迁移工作台支持从 MS Access 迁移。 了解更多。
edit
编辑
Because I don't use MS Access myself I missed an important point: SQL Developer doesn't support migration from Access 2007. However, according to this threadon the OTN SQL Developer forum, it can be made to work with the latest version of SQL Developer (that is, 2.1).
因为我不使用的MS Access我自己，我错过了一个重要的观点：SQL Developer不从Access 2007年。但是支持迁移，按照此主题在OTN SQL Developer的论坛，它可以使得工作与最新版本SQL Developer（即 2.1）。
