migrating MySQL data to Oracle

One. Server local installation oracle11g or 10G

Two. Create a tablespace in the run input sqlplus/nolog,oracle.

Three. After the installation is complete, enter SQL developer in the run to open SQL Developer (this is the native)

Four. Select the JDK path (the JDK version corresponds to the version of Oracle installed). Choose the package under the JDK file that comes with the Oracle Installation path folder

Five. Migrating MySQL data to Oracle:

Download the Mysql-connector-java-5.1.15-bin.jar package.

1. Add Driver: Menu bar-Tools-preferences-database-third-party JDBC driver, select Add entry, import jar package.

2. View-Connect-New Connection (Oracle database)

Either log in to the Administrator account SYS or the SYSTEM account to create a new account under the ORCL database server test

or re-create a database server name is also OK, look at their own needs.

Select Oracle, role selection, connection type selection, enter the connection name (any input), username and password, click Test Test Connection. If the status is successful, the connection succeeds. Click Save.

This database is the new database server name that I created myself.

Then the user on test this database server creates a new user to transfer the data to this account.

The ability to create passwords and authorize new users is here.

--Create the user
Create User TEST

Identified by TEST
Default Tablespace USERS
Temporary tablespace TEMP
Profile DEFAULT;
--Grant/revoke role privileges
Grant connect to TEST with admin option;
Grant resource to TEST with admin option;
--Grant/revoke System privileges
Grant ALTER any role to TEST;
Grant ALTER any sequence to TEST;
Grant alter any table to TEST;
Grant ALTER any trigger to TEST;
Grant Alter TABLESPACE to TEST;
Grant Comment any table to TEST;
Grant create any sequence to TEST;
Grant create any table to TEST;
Grant create any trigger to TEST;
Grant create any view to TEST;
Grant create materialized view to TEST with admin option;
Grant create public synonym to TEST with admin option;
Grant create role to TEST;
Grant create session to TEST with admin option;
Grant create synonym to TEST with admin option;
Grant create tablespace to TEST;
Grant create user to TEST;
Grant CREATE view to TEST with admin option;
Grant drop any role to TEST;
Grant drop any sequence to TEST;
Grant drop any table to TEST;
Grant drop any trigger to TEST;
Grant drop tablespace to TEST;
Grant drop user to TEST;
Grant Grant any role to TEST;
Grant insert any table to TEST;
Grant Select any table to TEST;
Grant Unlimited tablespace to TEST with admin option;
Grant update any table to TEST;

Select MySQL, enter the connection name (any input), username, password, click to select the database, the root of the database will be displayed. Click Test Test Connection. If the status is successful, the connection succeeds.

Click Save to save to the left of the connection tree view.

3. Porting-Repository Management-Create an archive database and create an archive database.

If the user name is test under the Oracle database you created, right-click or some version is associated with the repository

After you have associated your database. The system automatically generates many default action table function stored procedures, etc. do not care about it.

Click to select the current repository

The menu tree on the left will appear in the Model menu.

4. Right-click on the Connection menu in the MySQL library to select the migrated database

Click the capture scheme to put the database into the captured model.

Click Close

5. Right-click to select Convert to Oracle model

Click Apply

The 6.mysql database goes into the transformed model,

Select Database, right-click, select Build

Generates statements for SQL-built tables, indexes, build triggers, build functions, stored procedures, and so on, in Oracle format, note that these statements cannot be replicated, and you need to delete some unwanted statements to execute in Oracle

usually have

The words are deleted because execution will be an error.

These three-line statements create users and permissions for the tablespace, and if there is a tablespace, you can execute these three statements, and automatically connect to the Tablespace to execute the following statement, and if there is no table space, you need to create the table space and execute it first. If you have created a tablespace and a user, you can delete these three statements.

These statements can be executed directly under a pre-created user.

If you have this CREATE TRIGGER statement, you do not need a trigger to delete the statement

7. Click the converted model, right-select the mobile data,

Select the source and destination connections, remove the tick, the target connection is the database you created or the one you used before, be sure to remove the previous tick.

By clicking OK, you can migrate all of the MySQL's corresponding table data to Oracle.

This will wait for a period of time, look at the size of the database, the middle of the information will appear in the attention, can be compared to the source database data and the database table data is consistent.

SQL Server Transfer to Oracle comparison simple one step can be used to reference the online data can be successful

migrating MySQL data to Oracle