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/