migrating MySQL to Oracle database using Oracle SQL Developer

Oracle SQL Developer is Oracle's official database management tool. This article uses Oracle SQL developer to perform the migration from MySQL to the Oracle database.

March 6, 2017

Operation Steps:

1. Create a migration repository user in the Oracle database

The repository user is not the user who receives the MySQL migration data, but the user who makes the data migration configuration.

The Oracle Create User command is as follows:

Create User  by Migrater; Alter User migrater account unlock; Grant  to Migrater; Grant  to Migrater; Grant Create  to Migrater; commit;

Note: Give the user DBA authority.

2. Create a new Oracle connection in SQL Developer

The connection to create Oracle in SQL Developer is simpler, as shown in:

3. Add a third-party jar package (MySQL)
To build a MySQL connection using SQL Developer, you need to add a MySQL driver package, adding the following method:

Click "Tools-" preferences "

In the Preferences panel, select the "database-third-party JDBC driver" on the left, click the Add Entry button below to select the MySQL driver jar package.

4. New MySQL Connection
After you add a third-party driver for MySQL, the configuration entries for MySQL appear in the New Connection page.

5. Associated Migration Data Archive
The migration repository needs to be associated before the database is executed, as follows:

Installation process:

Many tables are added to the newly created Oracle Database after association:

6. Porting MySQL database to Oracle database
Right-click on the MySQL database connection that requires data migration and select the "Migrate to Oracle ..." menu.

When the operation is complete, a user with the same name as the MySQL database is created in the Oracle database and the user connects to the database to see all the migrated tables.

migrating MySQL to Oracle database using Oracle SQL Developer