ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Olusesi Ibrahim Adebisi , Senior DBA and Technical Lead Database Projects , MTN Nigeria
تاريخ النشر: 2016/02/15
Vinay Kumar
من قبل 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
من قبل Muhammad Mursaleen , Principal Software Engineer , Tower Technology

use oracle sql developer to migrate data from mysql to oracle

ahmed ali
من قبل 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
من قبل Khaja Afzaluddin , Oracle Database Administrator , GYG IT Solutions Pvt. Ltd

I would prefer Golden Gate.

Santhanapandi Pandian
من قبل 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
من قبل 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
من قبل 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.

المزيد من الأسئلة المماثلة