View Full Version : From access to oracle
jonmich
Mar 23, 2005, 12:23 AM
Hello
Can anyone help me, I have to convert an access database to an oracle database.
Is there someone who can help me?
LTheobald
Mar 23, 2005, 05:55 AM
Try the Oracle Migration Workbench (free download):
http://www.oracle.com/technology//tech/migration/workbench/index.html
ScottGem
Mar 23, 2005, 06:41 AM
The tool LT linked to looks good. However, since Access and Oracle are very different tools, it might be better to design the database in Oracle taking advantage of Oracle's strengths. Then Append the data to the Oracle tables. You can do this by connecting to the Oracle database from within Access using ODBC. Then run append queries, adding the data to the Oracle tables as appropriate.
jonmich
Mar 23, 2005, 06:58 AM
Could yo give me a litle bit more explanation Scott?
I don't quite understand what you mean
ScottGem
Mar 23, 2005, 04:46 PM
What didn't you understand. Not sure how I can restate it.
jonmich
Mar 23, 2005, 11:48 PM
How I have to append the data to the oracle database?
Is this just by export in the menu?
ScottGem
Mar 24, 2005, 06:32 AM
No, you have to create an Append query. Very likely, the structure in Oracle will be different then the structure in Access. Not vastly different, but possible different enough so that you can't just copy table to table.
Look up Append queries in Access Help. It will explain how to create them.