Migrate oracle data tables with Chinese to mysql

Source: Internet
Author: User
Tags converto
Oracle Data Tables with Chinese characters can be migrated to tables in mysqloracle to mysql. You can use the convertomysql tool online, but it cannot solve the migration problem of data tables with Chinese characters, I had to use plsql to manually export the table with Chinese data in excel format, pay attention to use editplus and other save as "uft-8 format csv file, then you can

Oracle Data Tables with Chinese characters can be migrated to mysql tables in oracle to mysql. The converto mysql tool is available online, but cannot solve the migration problem of data tables with Chinese characters, you have to use pl/SQL to manually export the table with Chinese data in excel format, pay attention to use editplus and other save as "uft-8" format csv file, then you can

Migrate data tables with Chinese characters from oracle to mysql
To migrate tables from oracle to mysql, you can use the converto mysql tool online, but it cannot solve the problem of migrating tables with Chinese characters, you have to use pl/SQL to manually export tables with Chinese data in excel format. Note that
To save editplus and other csv files in "uft-8" format, you can then in phpmyadmin
, Use csv load data to import data correctly. For details, refer:
Http://www.slyar.com/blog/phpmyadmin-csv-mysql.htmlthe first floor of cuishuangjia 15 hours ago
DBTOOLS supports conversion between ORACLE, MYSQL, SQLSERVER, POSTGRE, and DB2 Databases
Currently, Chinese and Japanese are supported.
Function:
1. Save the table structure and data in the database to EXCEL.
2. Synchronize the data in EXCEL to the database.
3. Data is not lost when the table structure changes.
4. Changes in table data before and after Program Execution
5. Generate the SQL statement for table creation based on the table structure in EXCEL.
6. When using the software, multiple users can record database operations of a user at any time.
7. You can automatically generate data for stress testing.
8. Export the table structure, which is different from the table structure in the database.
9. Export the DB structure, and perform table structure difference with the existing environment DB
10. Export the User-Defined table structure, import according to the table structure, verify the database for EXCEL validation before importing data
And business logic verification
11. Standalone test, combined with the test solution.

Email by: cuishuangjia@gmail.com
Penguin Group: Database third-party tool exchange 184715368


DbTools YouTu display video
Http://youtu.be/jfRwDUpPRLw

Baidu online storage:
Http://pan.baidu.com/s/1pCjPt
(Including video files)

At present, the permanent registration code is available free of charge during the test, basically meeting the needs for database operations at work.
ITEYE blog: http://cuishuangjia.iteye.com/

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.