Kettle的Oracle数据库表向MySQL数据库迁移

た入场券 2022-01-22 13:43 449阅读 0赞

###### 1.使用工具 ######

**kettle/Oracle/MySQL**

###### 2.使用方法kettle迁移 ######

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmRlbGlu_size_16_color_FFFFFF_t_70]

###### 3.执行过程错误处理 ######

执行:

CREATE TABLE test
    (
      TABLE_NAME VARCHAR(30)
    , file_CACHE VARCHAR(7)
    ) 时发生错误
    org.pentaho.di.core.exception.KettleDatabaseException: 
    Couldn't execute SQL:

通过查找得到：  
【将数据从oracle迁移到mysql，需要先在kettle中建立oracle和mysql数据库连接，注意mysql-connector-java-5.1.45.jar和ojdbc14-10.2.0.1.0.jar要在kettle启动之前拷贝进去。】  
于是只是下载了ojdbc14-10.2.0.1.0.jar，将其放到了kettle的路径：E:\\data-integration\\lib下，下载地址为：[http://www.java2s.com/Code/Jar/o/Downloadojdbc14102020jar.htm][http_www.java2s.com_Code_Jar_o_Downloadojdbc14102020jar.htm]

##### 如下所示： #####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmRlbGlu_size_16_color_FFFFFF_t_70 1]

将其放到了kettle的路径：E:\\data-integration\\lib下，重新执行转换，发现还是报错

CREATE TABLE test
    (
      TABLE_NAME VARCHAR(30)
    , file_CACHE VARCHAR(7)
    )
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNKNOWN
    , file1VARCHAR(3)
    , file2VARCHAR(12)
    , file3 CHAR(1)
    ' at line 34

于是放到sqlyong中，改变语句，进行调试，重新执行，就解决了。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmRlbGlu_size_16_color_FFFFFF_t_70]: /images/20220122/11caa766c6874547b8f630e19b701f63.png
[http_www.java2s.com_Code_Jar_o_Downloadojdbc14102020jar.htm]: http://www.java2s.com/Code/Jar/o/Downloadojdbc14102020jar.htm
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RhbmRlbGlu_size_16_color_FFFFFF_t_70 1]: /images/20220122/b1a62fa52a0d459188462a1ce4669c15.png