powerdesigner 同步mysql 报错_oracle数据迁移到mysql

Kettle7.0实现oracle到mysql数据库迁移(批量全量导入)

https://blog.csdn.net/j1231230/article/details/80525922

Kettle 增量数据导入(仅支持添加)

https://www.cnblogs.com/mq0036/p/9238646.html

使用KETTLE从mysql同步增量数据到oracle(单表增量导入)

https://my.oschina.net/forever9999/blog/2221407?tdsourcetag=s_pctim_aiomsg

示例下载：

链接：https://pan.baidu.com/s/13-mixpNVifTyHSu1B0u2Vw

提取码：vyqw

其余参考：

oracle数据库迁移到MySQL的方法总结：

https://www.jb51.net/article/109536.htm

使用 Navicat_premium 将 oracle 数据库迁移到 mysql

https://blog.csdn.net/wangzhi291/article/details/62422168

将oracle的数据导入到mysql的三种方法

https://www.2cto.com/database/201606/513843.html

oracle数据迁移到mysql

https://www.cnblogs.com/duwenlei/p/3520759.html

oracle特有类型导入mysql报错，date类型精确度降低，未使用navicat

oracle数据转到mysql----PowerDesigner16.5 工具

https://blog.csdn.net/qq_41889087/article/details/80355201

从本地 Oracle 迁移到 RDS for MySQL

https://help.aliyun.com/document_detail/26620.html

Oracle Goldengate数据库复制与容灾项目实施维护_OGG实战培训_数据库容灾与复制04

http://edu.51cto.com/course/8441.html?utm_source=baidu&utm_medium=sem&utm_term=Oracle&utm_content=1&qd=sem

datax windows下安装及使用(linux)

https://blog.csdn.net/china_xin1/article/details/82873987

使用navicat迁移报错：

oracle特有类型导入mysql报错：

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 ‘:“STUDENT”, :“COURSE”, ‘55’)’ at line 1 With statement: INSERT INTO CC VALUES (:“STUDENT”, :“COURSE”, ‘55’)