Shulou(Shulou.com)06/01 Report--

This article is mainly about the steps of migrating MySQL database content to Oracle through SQL Developer tools. If you are interested, let's take a look at this article. I believe that after reading the steps of migrating MySQL database content to Oracle through SQL Developer tools, it is of some reference value to everyone.

For business requirements, the content of MySQL database needs to be migrated to Oracle database, with a data volume of about 300g. For convenience, migrate through Oracle's own tool SQLDeveloper, as follows:

Download the mysql-connector-java-5.1.24 driver and store it in the C:\ sqldeveloper\ jlib directory

Configure mysql-connector third-party drivers

Link to MySQL and Oracle databases

Create a MySQL migration database

Create ORACLE migration user

Create user migrater identified by * defualt tablespace migration

If you don't know which permissions need to be granted, you can give DBA permissions directly.

Grant dba to migrater

Migrater users for SQLDeveloper links

5. Follow the steps shown in the figure. Select the conversion rules in which each field is converted from MySQL to Oracle in the conversion item. After configuration, a schema with the same name as the MySQL database will be generated in the oracle library, where is the data to be converted.

Finally, use the data pump to import more, and design the schema type for the structure you need!

Does the above detailed steps for migrating MySQL database content to Oracle through the SQL Developer tool help you? If you want to know more about it, you can continue to follow our industry information section.

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.