MS Access 到 Oracle 轻松转换/迁移

MS Access to Oracle easy Conversion / Migration(MS Access 到 Oracle 轻松转换/迁移)

本文介绍了MS Access 到 Oracle 轻松转换/迁移的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

Are there any good easy to use softwares to export Access Database files to an Oracle 11g database?

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.

Tutorials and articles regarding Access 2003 and 2007 migrations would be preffered.

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

However I am on a Windows enviornment and mdbtools seems to be a Linux-only tool.

解决方案

The Migration Workbench which comes with Oracle's (free) SQL Developer tool supports migrating from MS Access. Find out more.

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 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 轻松转换/迁移的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:MS Access 到 Oracle 轻松转换/迁移

基础教程推荐