I wonder whether any one had done a migration from FoxPro to Oracle. Is there any tools available from oracle, or do I still have to go by the old method of using sqlloader to load the data.
I'm looking for a way to replicate the entire FoxPro Schema into oracle.
Any known tools or suggestions on how to do this?
there is a workaround which i used in one of my recent projects the trick was fooling oracles migration assistant for acesses here is hwo it works.
1) first import foxpro database into Ms-Acesses
2)then use oracle migration assistant for aceses to import it into oracle
hope this helps
For moving your data try a migration software at http://www.ispirer.com/chyfo.html
It provides you the fastest, the easiest and the most powerful way to migrate your database into Oracle.
It allows you to extract any data from any database. It works in conjunction with Oracle SQL Loader.
The tool creates text files (CSV, TAB, fixed lenght), generates CREATE TABLE, CREATE INDEX scripts for Oracle and control files for SQL Loader.
Moving of LOBs are fully supported.
The utility has a lot of other features.
Best regards, Dmitry.