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:

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

How To Negotiate Your Compensation As a Programmer Every Year

Executing the python Script

Why Equals is a Powerful Operator To Help You Write Cleaner Code

Dealing with Arrays in GraphQL Ruby

PDX phase 33 project progress weekly report: November 9 — November 22

Transaction Slippage Review: Comparison of 3 DEX Platforms (BSC Chain)

Creating Your First Python Program

Case Class in Scala

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

Sharp Notes to SQL Users Migrating to DynamoDB

Swagger VS OpenAPI

Application Framework

Database Replication with Change Data Capture over Kafka