Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the best approach to migrate data from MySQL database 5.6 to Oracle 11gr2?

user-image
Question ajoutée par Olusesi Ibrahim Adebisi , Senior DBA and Technical Lead Database Projects , MTN Nigeria
Date de publication: 2016/02/15
Vinay Kumar
par Vinay Kumar , Role: CTI/IVR/Jave Developer, Designation: AM , TATA Communications Ltd.

I think we have migrate only data, so we can develop application which is responsible to copy data from mysql to oracle with meta data

Muhammad Mursaleen
par Muhammad Mursaleen , Principal Software Engineer , Tower Technology

use oracle sql developer to migrate data from mysql to oracle

ahmed ali
par ahmed ali , Database Administrator , Compass International LLC

MySQL and Oracle Database are complementary databases best suited to different use cases. In cases where you need to migrate, SQL Developer is a free and fully supported product that provides tools and utilities to migrate from MySQL to Oracle. 

Khaja Afzaluddin
par Khaja Afzaluddin , Oracle Database Administrator , GYG IT Solutions Pvt. Ltd

I would prefer Golden Gate.

Santhanapandi Pandian
par Santhanapandi Pandian , Database Administrator , mGage

 

We can migrate from the Tools , we have lot of tools are available like  DBConnect, DNSync and ESF migration Tools like etc.

 

i already tested and migrated successfully from MySQL to Oracle DB.

 

Mohammed Irfan Hussain
par Mohammed Irfan Hussain , Oracle DBA ( Database Administrator) , Ministry of environment water and agriculture, Saudi Arabia

The Best Approach i would prefer is Golden Gate for migration from mysql to Oracle ,

Indeed Golden Gate's Vendor is Oracle itself.

Below links may give an idea of migration.

 

http://www.practiceoracledba.com///goldengate-for-mysql-to-oracle.html

https://docs.oracle.com/cd/E9_/doc./e9.pdf

Imran Shaikh
par Imran Shaikh , Database Specialist Exadata,Oracle ERP , Government of Abudhabi

 

 

MySQL and Oracle Database are complementary databases best suited to different use cases. In cases where you need to migrate, SQL Developer is a free and fully supported product that provides tools and utilities to migrate from MySQL to Oracle.

migration process is to convert the captured model of the database to an Oracle-specific model. The captured model contains data types, naming schemes etc. defined by your database vendor; this now must be converted to Oracle formats.

More Questions Like This