migrating MySQL to Oracle database using Oracle SQL Developer

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.