views:

103

answers:

1

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.

+4  A: 

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 to Access 2007. Howver, 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).

APC
Unfortunatly that Requires that you have Office 2003 and it doesn't really support all Access formats for example dates. Any other suggestions?
Filip Ekberg
Could you provide a link explaining those points? I admit I haven't undertaken an Access to Oracle migration, but the documentation suggests that they map MS Access dates to Oracle dates, and that it supports versions of Access dating back to 97.
APC
By "doesn't support migration to Access 2007" do you mean that it doesn't support importing data into Oracle from ACCDB format databases?
David-W-Fenton
Filip - Please be specific as to what formats don't work. I find it hard to beleive that Access date fields can't be converted over to Oracle or any other database. Same with other data formats.
Tony Toews