Oracle To Postgres, MySQL or MS Access Migration

Question

I have an Oracle 8i database running on 2000 NT server.

I have been assigned a task to copy data along with schema into any of these

(postgresql, mysql, ms access)

I have tried a lot in the internet but there is no such tool which could help me. Right now I am running that NT 2000 in virtual machine using VM WARE.

Fionnuala · Accepted Answer · 2012-01-20 13:43:29Z

1

It is not too difficult to link Oracle to MS Access, from which point it is just a matter of running queries, if you need the data to be physically held in MS Access.

More info: http://www.orafaq.com/node/60

answered Jan 20, 2012 at 13:43

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gsiems · Accepted Answer · 2012-01-20 16:26:09Z

1

For copying the schema/data to PostgreSQL there is ora2pg. If this is a recurring task then one nice thing about ora2pg is that you can potentially script/automate the process.

For a one-time or ad-hock export, and depending on the nature and size of the database, you can also use DbVisualizer to export the schemas/data.

answered Jan 20, 2012 at 16:26

gsiems

3,8201 gold badge25 silver badges24 bronze badges

Collectives™ on Stack Overflow

Oracle To Postgres, MySQL or MS Access Migration

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related