Site icon Database Tutorials

How To Migrate From MySQL To Oracle

In this guide, we will explore the step-by-step process of migrating from MySQL to Oracle, covering key concepts, tools, and best practices to ensure a successful transition.

The tool we will use for the migration process will be “Oracle SQL Developer”.

To give information about databases.

MySQL DB

Oracle DB

1. First, we connect to our MySQL and Oracle databases to check our connections.

2. We create a SCHEMA that will be used as a REPOSITORY in the Oracle database we are connected to, and the permissions to be given to this schema are as follows.

3. Then we connect to our Oracle database with this user.

4. We create MIGRATION REPOSITORY under the SCHEMA we created in our Oracle database.

5. Screens like the one below will appear.

6. We will start the transfer process by following the steps below.

i. We click on the database we will transfer and select the “Migrate To Oracle” option.

ii. We pass the first step.

iii. We select the REPOSITORY we created and click the NEXT button.

iv. We fill in the blanks as follows.

v. The database to be MIGRATED is selected.

vi. We select the MySQL database.

vii. The following step shows the DATA TYPE change when performing MIGRATION between databases.

viii. We select the database objects to be TRANSLATE.

ix. We enter our Oracle database, which will be our new database, as follows. This is the database we connect to with the SYS user.

x. The last step shows the result.

xi. The summary is as follows.

xii. The MIGRATE process will proceed as follows.

xiii. The result of the operation should be as follows.

7. Now that we have completed the MIGRATION process, we can check the tables. First, we check the tables on the MySQL side and then on the Oracle side.

MySQL

Oracle

8. Finally, let’s check the row numbers.

MySQL

Oracle

Exit mobile version