MS Access对Oracle的轻松转换/迁移 [英] MS Access to Oracle easy Conversion / Migration
问题描述
是否有任何易于使用的优质软件将Access Database文件导出到Oracle 11g数据库?
Are there any good easy to use softwares to export Access Database files to an Oracle 11g database?
我知道这可能不是最常见的情况,但是应用程序会增长,特别是在使用旧技术(例如Access)的旧应用程序中,需要在某个时候进行升级.
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 2003和2007迁移的教程和文章.
Tutorials and articles regarding Access 2003 and 2007 migrations would be preffered.
有一个名为mdbtools的工具,可以通过执行以下操作来提供帮助:
There is a tool called mdbtools which would help by doing something like this:
for i in *.mdb;do mdb-schema $i oracle > $i.schema.sql;done
但是我在Windows环境中,而mdbtools似乎是仅限Linux的工具.
However I am on a Windows enviornment and mdbtools seems to be a Linux-only tool.
推荐答案
Oracle(免费)SQL Developer工具附带的迁移工作台支持从MS Access迁移. 了解更多信息.
The Migration Workbench which comes with Oracle's (free) SQL Developer tool supports migrating from MS Access. Find out more.
修改
因为我自己不使用MS Access,所以我错过了重要的一点:SQL Developer不支持从Access 2007进行迁移.但是,根据
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 thread on the OTN SQL Developer forum, it can be made to work with the latest version of SQL Developer (that is, 2.1).
这篇关于MS Access对Oracle的轻松转换/迁移的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!