Database migration-Oracle and MySQL conversion

In theory, MySQL has been acquired by Oracle, and Migrate between the two should be relatively easy, but the actual migration still has some problems. Let me talk about some implementation methods and problems.

Method 1: Import and export manually

Manual import means that the operation steps will be more complicated.

Table structure and data:

1. Use SQL Developer to export the schema and Data (.sql and .xls) of the oracle table

2. Use MySQL WorkBench to create Table and import data.

The syntax here will be slightly different, so some adjustments are required.

For View, especially the complex OracleView with subqueries, it seems that it is not so easy to import into MySQL.

Method 2: Use the tool Navicat to import

Navicat, this is a tool recommended by someone on the official MySQL website. This is a paid software. The current fee is $200 to $300 doller. But you can try it for free for a month.

Reference Link: https://developpaper.com/summary-of-methods-for-oracle-database-migrating-to-mysql/

Thanks for reading this post.

Pankaj K.

--

--

--

Database/System Administrator | DevOPS | Cloud Specialist | DevOPS

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Algorithmic trading system for stocks

CadBerry Devlog 2: VS Code, Modules, and Viewports

GS002: Making our Player move

Easily Deploy And Win Prizes | The Decentralized Cloud of StackOS

Protocol Buffer with Maven

Ups and Downs in my .net journey

How to use Streamlit, Pandas and Plotly to create an interactive dashboard with earthquake data…

Six Reasons Hex and Snowflake Work Great Together

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Pankaj kushwaha

Pankaj kushwaha

Database/System Administrator | DevOPS | Cloud Specialist | DevOPS

More from Medium

DATABASE NORMALISATION

Elastic Beanstalk for Instant Development and Flask App Deployment.

Docker Inside Docker

How to Install External Solr Server