开发者

DB in MySQL migrate to Oracle DB

开发者 https://www.devze.com 2022-12-15 06:42 出处:网络
I need to migrate some tables in开发者_StackOverflow中文版 mysql db to oracle db. Do you now any tutorial to learn about this migration?

I need to migrate some tables in开发者_StackOverflow中文版 mysql db to oracle db.

Do you now any tutorial to learn about this migration?

Thanks


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.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消