I have an Microsoft Access 2002 database with a number of look up tables and was wondering how I would go about migrating this to Oracle using FME 2015 while keeping the relationships between the main table and the look up tables.
Thanks
Solved
Migrating Access Database to Oracle
+1Hi,
Best answer by david_r
Hi
The simplest solution is to use the functionality in File / New / Generate workspace to set up the workspace for you.
FME is amazing at translating data, but translating relations etc. isn't its strong suit, so you'll mostly have to define the foreign keys, indexes etc. manually in Oracle. You can use something like Toad or SQLDeveloper for this, they make it fairly easy to do in a user-friendly interface.
David
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- Best Answer
Hi
The simplest solution is to use the functionality in File / New / Generate workspace to set up the workspace for you.
FME is amazing at translating data, but translating relations etc. isn't its strong suit, so you'll mostly have to define the foreign keys, indexes etc. manually in Oracle. You can use something like Toad or SQLDeveloper for this, they make it fairly easy to do in a user-friendly interface.
David
Hi,
Agree that using a tool like SQL Developer is easier way, but if you are familiar with SQL syntax, you can also add required constraints (foreign keys etc.) to the destination database by setting the SQL statements directly into the "SQL Statement To Execute After Translation" parameter of the writer.
Takashi