DM不能同步有外键的表吗

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:DM2.0.0
  • 【问题描述】:
    task中的报错:

“id”: 6,
“name”: “table structure compatibility check”,
“desc”: “check compatibility of table structure”,
“state”: “fail”,
-------- warning options ----------\ information: Foreign Key pub_holiday_date_ibfk_1 is parsed but ignored by TiDB.\ instruction: please ref document: https://github.com/pingcap/docs-cn/blob/master/sql/ddl.md\

worker中的报错:
[2020/11/24 09:47:14.694 +08:00] [ERROR] [common.go:35] [“parse statement”] [sql="SAVEPOINT 4454c604-d588-4a64-8907-eff8c484124a-savepoint-1"] [error="line 1 column 9 near "SAVEPOINT 4454c604-d588-4a64-8907-eff8c484124a-savepoint-1" "]
[2020/11/24 09:47:14.722 +08:00] [ERROR] [common.go:35] [“parse statement”] [sql="SAVEPOINT b2495e95-be26-4223-8ca1-9845c5b6bee8-savepoint-1"] [error="line 1 column 9 near "SAVEPOINT b2495e95-be26-4223-8ca1-9845c5b6bee8-savepoint-1" "]

若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。

补充一下,DM是1.0.2版本

TiDB 本身不支持外键约束,兼容性文档可以参考下:
https://docs.pingcap.com/zh/tidb/dev/mysql-compatibility

DM 中,如果遇到了 TiDB 不支持的 DDL 操作,可以使用 sql-skip 或者 sql-replace ,操作文档参考:
https://docs.pingcap.com/zh/tidb-data-migration/v1.0/skip-or-replace-abnormal-sql-statements#sql-skip