Shulou(Shulou.com)05/31 Report--

This article shares with you the content of a sample analysis of the migration of oracle databases to MySQL. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Method 1: import and export manually

Import manually, but the operation steps will be more cumbersome.

For the structure and data of Table:

1. Use SQL Developer to export schema and Data (.sql and .xls) of oracle's table

two。 Use MySQL's WorkBench to create Table and import data.

The syntax here will be a little different, so you need to make some adjustments.

For View, especially the complex Oracle View with subqueries, it doesn't seem so easy to import into MySQL.

Method 2: use the tool Navicat for import

Http://www.navicat.com.cn

Navicat, a tool suggested by some people on MySQL's official website. This is a paid software. The current charge is 1000 to 1600 yuan. But you can try it for free for a month.

After downloading and installing, the launch page is as follows:

The process of migration is as follows:

1. Create a new connection to the database

Establish database connections for Oracle and MySQL that need to be migrated.

In addition, you need to download an oci.dll file when establishing an Oracle connection.

Download address: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

After downloading, extract it to a directory:

Make settings similar to the following under the tool-> option of Navicat:

For details, please see: http://wiki.navicat.com/wiki/index.php/Instant_client_required

After completing the setup, restart navicat

two。 After setting up the connection, you can then migrate the tables and data

Click: tools-- "data transfer

Set up the connection that requires migrate in the General tab

In the Advanced tab, set what specific content of migrate is required:

After the configuration is complete, click "start".

Basically: there is basically no problem with the structure of Table and the migration of data.

But for the import of View, because the syntax of MySQL's View cannot have subquery statements.

On Navite, you can see that when importing from Oracle to MySQL, the Checkbox of View cannot be selected.

Method 3: import using the OracleToMySQL of the tool DBMover

The website DBMover also provides tools for Oracle to MySQL migration.

Download address: http://dbmover.com/download/oracletomysql_cn.zip

This is also a paid software, and the limit of the trial version is that the cumulative number of records allowed to migrate is 100000.

Download and install, after startup, you will be asked to enter the information of the database connection:

The page after the configuration has been completed is:

Only table can be seen here.

Compared with Navicat, I feel that this is simple, can only be migrate table, and it is not very convenient to use.

The next time Migrate has to be typed again from beginning to end, there is no way to remember the previously configured connection.

Method 4: import using the oracle-to-mysql of the tool intelligent-converters

It is also a charging tool:

Download address: http://www.intelligent-converters.com/oracle-to-mysql.htm

The limit for using the version is that only 5 pieces of data can be imported per table.

The mode of operation is similar to that provided by DbRemover. The advantage is that you can remember some of the connection information from last time.

Also, tables can only be imported.

Imported pages:

Thank you for reading! This is the end of this article on "sample analysis of oracle database migration to MySQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.