Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
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
use oracle sql developer to migrate data from mysql to oracle
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.
I would prefer Golden Gate.
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.
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
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.