DB in MySQL migrate to Oracle DB

Question

I need to migrate some tables in mysql db to oracle db.

Do you now any tutorial to learn about this migration?

Thanks

If you've accepted it, why not vote it up as well?

duffymo
– duffymo

2009-12-30 17:31:28 +00:00
Commented Dec 30, 2009 at 17:31 — duffymo
– duffymo, Commented Dec 30, 2009 at 17:31
Wait a little : you will get a new sticker :P

Hugues Van Landeghem
– Hugues Van Landeghem

2009-12-30 17:50:07 +00:00
Commented Dec 30, 2009 at 17:50 — Hugues Van Landeghem
– Hugues Van Landeghem, Commented Dec 30, 2009 at 17:50

OMG Ponies · Accepted Answer · 2009-12-30 17:33:41Z

3

You can connect to the MySQL instance from Oracle using Oracle's database link - this link details making the connection from Oracle to MySQL.

Bearing in mind that the MySQL account you use to create the connection will determine access to MySQL data, once the link is created you can work within Oracle to select data from the MySQL tables into the Oracle tables without a need for scripts and such.

answered Dec 30, 2009 at 17:33

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

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

Comments

duffymo · Accepted Answer · 2009-12-30 17:27:42Z

3

Find an ETL tool like Informatica or SSIS to help you. Oracle's Migration Workbench might be the perfect choice, since you're already using Oracle.

answered Dec 30, 2009 at 17:27

duffymo

310k46 gold badges377 silver badges572 bronze badges

Collectives™ on Stack Overflow

DB in MySQL migrate to Oracle DB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related