Q
Problem solve Get help with specific problems with your technologies, process and projects.

Migrating Access and FoxPro data to Oracle

How can we migrate Access and FoxPro tables and data into Oracle?

If you want to get real fancy, you can visit Technet and download a copy of the Oracle Migration Workbench. This is a wizard-driven tool which lets you migrate from one database system to Oracle. The list of systems you can migrate from include MS Access.

Unfortunately, FoxPro is not listed. Probably the easiest option is to use whatever tools are available in FoxPro to dump the tables to a set of files, comma-delimited or otherwise. Then, use Oracle's SQL*Loader utility to load these files into the Oracle database. This also works for MS Access if you do not wish to use the Migration Workbench.

For More Information


Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close