1ã è¿è¡MySQL Migration Toolkitï¼ä¸è·¯âNextâå°âSource Databaseâï¼å¨Database Systemä¸éæ©Oracle Database Serverï¼å¦æ第ä¸æ¬¡ä½¿ç¨ä¼åä¹è¦æ±å 载驱å¨ç¨åºojdbc14.jarã
å 载驱å¨ç¨åºä¹åï¼çé¢å°åæå¦ä¸çå½¢å¼ï¼å¨å
¶ä¸å¡«åOracleæ°æ®åºçè¿æ¥ä¿¡æ¯ï¼æâNextâ继ç»ã
2ã å¨Target Databaseä¸é»è®¤Database System为MySQL Serverï¼å¨Connection Parametersä¸å¡«åç¸åºçMySQLæ°æ®åºçè¿æ¥ä¿¡æ¯ï¼æâNextâ继ç»ã
3ãè¿è¡æ°æ®åºè¿æ¥æµè¯ï¼æµè¯éè¿åæâNextâå°Source Schemata Selectionï¼ç¹éåå¤è¿è¡æ°æ®è¿ç§»çSchemataåæâNextâ继ç»ã
4ãå¨Object Type Selectionï¼ç¹Detailed selectionæé®ï¼å¨ä¸æ¹å·¦ä¾§å表ä¸éæ©ä¸è¿è¡è¿ç§»ç表ï¼å°å
¶æ¾å
¥å³ä¾§å表ä¸ï¼å³å·¦ä¾§å表å©ä½ç表é½å°è¿è¡æ°æ®è¿ç§»ãéæ©å¥½ä¹åæâNextâ继ç»ã
5ãå¨Object MappingçMigration of type Oracle Schemaï¼å¦æè¦è®¾ç½®åæ°ï¼ç¹Set Parameteræé®ãå¦æé»è®¤æ°æ®åºè¡¨ä¸ºUTF8çè¯ï¼åéæ©Multilanguageï¼å¦æé»è®¤æ°æ®åºè¡¨ä¸ºGBKçè¯ï¼åéè¦éæ©User definedï¼å¹¶å¨ä¸æ¹å¡«åcharset=gbk, collation=gbk_general_ciãMigration of type Oracle Tableä¸è¦è®¾ç½®åæ°ç¹Set Parameteræé®ãå¦æé»è®¤æ°æ®åºè¡¨ä¸ºUTF8çè¯ï¼åéæ©Data consistency/multilanguageï¼å¦æé»è®¤æ°æ®åºè¡¨ä¸ºGBKçè¯ï¼åéè¦éæ©User definedï¼å¹¶å¨ä¸æ¹å¡«åaddAutoincrement=yes, charset=gbk, collation=gbk_general_ci, engine=INNODBãéæ©å¥½ä¹åæâNextâ继ç»ã
6ãåå°Manual Editingï¼å¨è¿éå¯ä»¥ä¿®æ¹å»ºè¡¨èæ¬ãç±äºOracleä¸MySQLä¹é´è¯æ³è§åçå·®å¼ï¼é常éè¦å¯¹èæ¬çæ°æ®ç±»å以åé»è®¤å¼è¿è¡è°æ´ï¼æ¯å¦Oracleä¸é常ä¼å¯¹Timestampç±»åçæ°æ®è®¾ç½®é»è®¤å¼sysdateï¼ä½å¨MySQLä¸æ¯ä¸è½è¯å«çãå¨Filterä¸éæ©Show All Objectsï¼ç¶åå¨Migrated Objectsä¸éæ©è¦ä¿®æ¹èæ¬ç表ï¼åç¹å»å·¦ä¸æ¹çAdvancedå°±å¯ä»¥è¿è¡èæ¬ç¼è¾äºãä¿®æ¹å®ä¹åç¹å»å³ä¾§Apply Changesæé®ä¿åï¼æâNextâ继ç»ã
7ãç¶åä¸è·¯âNextâï¼å¦æ没ææ示åºéçè¯ï¼å°±å¯ä»¥å°æå®è¡¨ä¸çæ°æ®å¯¼å
¥MySQLäºãå¦æææ示åºéä¿¡æ¯ï¼åéè¦è¿åå°Manual Editingå¤å¯¹èæ¬éæ°è¿è¡ä¿®æ¹ã
éè¦è¡¥å
ä¸ç¹ï¼å¨å¯¼å¤§å®¹éæ°æ®ç¹å«æ¯CLOBæ°æ®æ¶ï¼å¯è½ä¼åºç°å¼å¸¸ï¼âPackets larger than max_allowed_packet are not allowedâãè¿æ¯ç±äºMySQLæ°æ®åºæä¸ä¸ªç³»ç»åæ°max_allowed_packetï¼å
¶é»è®¤å¼ä¸º1048576(1M)ï¼å¯ä»¥éè¿å¦ä¸è¯å¥å¨æ°æ®åºä¸æ¥è¯¢å
¶å¼ï¼
show VARIABLES like '%max_allowed_packet%';
ä¿®æ¹æ¤åæ°çæ¹æ³æ¯å¨mysqlæ件夹æ¾å°my.iniæ件ï¼å¨my.iniæ件[mysqld]ä¸æ·»å ä¸è¡ï¼
max_allowed_packet=16777216
éå¯MySQLï¼è¿æ ·å°å¯ä»¥å¯¼å
¥ä¸å¤§äº16Mçæ°æ®äºï¼å½ç¶è¿æ°å¼å¯ä»¥æ ¹æ®éè¦ä½è°æ´ã
温馨提示:答案为网友推荐,仅供参考