Oracle to MySQL latest effective method

Source: Internet
Author: User

Keyword: Oracle to MySQL, Oracle to MySQL
Okay, try it. Navicat family's new product Navicat Premium, he integrates Oracle, MySQL and PostgreSQL management as one, personal feeling very strong (feel Fast)!

On the whim, can oracle import MySQL? Try it first:

1) New Oracle connection and MySQL connection
2) data transfer with tools (e.g.)

3) point start, import altogether started
Import finished, look at the effect of the import, very good, but there are some problems, need to manually change:
1) Oracle autogrow fields are generally controlled by "sequence", so the auto-grow fields that are imported seem to have no autogrow properties
2) Primary key, index, etc. may also be imperfect
3) Coding problem, Navicat Premium export data by default appears to be the utf-8 format, specific MySQL and Oracle code at your discretion
Overall very good, change it yourself

Oracle to MySQL latest effective method

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.