transferdb:Transferdb支持异步数据库模式转换,全量数据导入,导入和增量数据同步功能(Oracle数据库-> MySQL数据库)

上传者: 42144604 | 上传时间: 2023-04-04 10:40:45 | 文件大小: 114KB | 文件类型: ZIP
Transferdb transferdb用于分布式数据库迁移(Oracle数据库-> MySQL数据库),现阶段支持的功能(原transferdb版本被重构): 支持表结构定义转换 考虑到Oracle分区表特殊且MySQL数据库复杂分区可能不支持,分区表统一认为普通表转换,但是reverse阶段日志中会打印警告【分区表】,若有要求,建议反向之后检查,需手工转换 支持自定义配置表分段类型规则转换(表->模式->内置) 支持规范配置规则转换 支持表索引创建 支持非空约束,外键约束,检查约束等 数据同步【数据同步需要存在主键或者唯一键】 FULL模式【全量数据导入导入】数据同步转换导入要求表中存在主键或唯一键,否则因异常错误退出或手工中断退出,断点续传【替换为】无法替换,数据可能会导致重复【除非手工清理下游重新导入】 ALL模式【全量导出导入+增量数据同步】 增量基于logminer日志

文件下载

资源详情

[{"title":"( 51 个子文件 114KB ) transferdb:Transferdb支持异步数据库模式转换,全量数据导入,导入和增量数据同步功能(Oracle数据库-> MySQL数据库)","children":[{"title":"transferdb-main","children":[{"title":"client","children":[{"title":"instantclient-basic-linux.x64-19.8.0.0.0dbru.zip <span style='color:#111;'> 133B </span>","children":null,"spread":false}],"spread":true},{"title":"go.mod <span style='color:#111;'> 983B </span>","children":null,"spread":false},{"title":"server","children":[{"title":"server.go <span style='color:#111;'> 2.24KB </span>","children":null,"spread":false}],"spread":true},{"title":"pkg","children":[{"title":"prepare","children":[{"title":"prepare.go <span style='color:#111;'> 1.42KB </span>","children":null,"spread":false}],"spread":true},{"title":"taskflow","children":[{"title":"applier.go <span style='color:#111;'> 1.97KB </span>","children":null,"spread":false},{"title":"translator.go <span style='color:#111;'> 9.52KB </span>","children":null,"spread":false},{"title":"taskflow.go <span style='color:#111;'> 3.77KB </span>","children":null,"spread":false},{"title":"extractor.go <span style='color:#111;'> 5.49KB </span>","children":null,"spread":false},{"title":"sqlparser.go <span style='color:#111;'> 4.98KB </span>","children":null,"spread":false},{"title":"payload.go <span style='color:#111;'> 13.48KB </span>","children":null,"spread":false}],"spread":true},{"title":"reverser","children":[{"title":"reverser.go <span style='color:#111;'> 11.11KB </span>","children":null,"spread":false},{"title":"table.go <span style='color:#111;'> 22.84KB </span>","children":null,"spread":false}],"spread":true},{"title":"config","children":[{"title":"config.go <span style='color:#111;'> 3.57KB </span>","children":null,"spread":false}],"spread":true},{"title":"signal","children":[{"title":"signal_windows.go <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"signal_posix.go <span style='color:#111;'> 1.53KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"db","children":[{"title":"sync_all.go <span style='color:#111;'> 8.12KB </span>","children":null,"spread":false},{"title":"postgresdb.go <span style='color:#111;'> 9.03KB </span>","children":null,"spread":false},{"title":"mysqldb.go <span style='color:#111;'> 3.37KB </span>","children":null,"spread":false},{"title":"sync_full.go <span style='color:#111;'> 10.86KB </span>","children":null,"spread":false},{"title":"model_custom.go <span style='color:#111;'> 5.18KB </span>","children":null,"spread":false},{"title":"oracledb.go <span style='color:#111;'> 4.22KB </span>","children":null,"spread":false},{"title":"model_meta.go <span style='color:#111;'> 5.38KB </span>","children":null,"spread":false},{"title":"reverser.go <span style='color:#111;'> 10.70KB </span>","children":null,"spread":false},{"title":"db.go <span style='color:#111;'> 2.62KB </span>","children":null,"spread":false}],"spread":true},{"title":"LICENSE <span style='color:#111;'> 11.09KB </span>","children":null,"spread":false},{"title":"go.sum <span style='color:#111;'> 90.61KB </span>","children":null,"spread":false},{"title":"util","children":[{"title":"constant.go <span style='color:#111;'> 950B </span>","children":null,"spread":false},{"title":"util.go <span style='color:#111;'> 2.00KB </span>","children":null,"spread":false},{"title":"string.go <span style='color:#111;'> 3.12KB </span>","children":null,"spread":false}],"spread":true},{"title":"README.md <span style='color:#111;'> 5.11KB </span>","children":null,"spread":false},{"title":".idea","children":[{"title":".gitignore <span style='color:#111;'> 39B </span>","children":null,"spread":false},{"title":"misc.xml <span style='color:#111;'> 179B </span>","children":null,"spread":false},{"title":"vcs.xml <span style='color:#111;'> 185B </span>","children":null,"spread":false},{"title":"transferdb.iml <span style='color:#111;'> 288B </span>","children":null,"spread":false},{"title":"codeStyles","children":[{"title":"Project.xml <span style='color:#111;'> 2.25KB </span>","children":null,"spread":false}],"spread":false},{"title":"dbnavigator.xml <span style='color:#111;'> 22.62KB </span>","children":null,"spread":false},{"title":"markdown-navigator-enh.xml <span style='color:#111;'> 2.12KB </span>","children":null,"spread":false},{"title":"watcherTasks.xml <span style='color:#111;'> 245B </span>","children":null,"spread":false},{"title":"modules.xml <span style='color:#111;'> 279B </span>","children":null,"spread":false},{"title":"markdown-navigator.xml <span style='color:#111;'> 3.42KB </span>","children":null,"spread":false}],"spread":true},{"title":"conf","children":[{"title":"reverse_test.sql <span style='color:#111;'> 5.87KB </span>","children":null,"spread":false},{"title":"config.toml <span style='color:#111;'> 2.45KB </span>","children":null,"spread":false}],"spread":true},{"title":"zlog","children":[{"title":"gorm.go <span style='color:#111;'> 3.19KB </span>","children":null,"spread":false},{"title":"zap.go <span style='color:#111;'> 1.16KB </span>","children":null,"spread":false}],"spread":true},{"title":".gitattributes <span style='color:#111;'> 93B </span>","children":null,"spread":false},{"title":"test","children":[{"title":"mysql.go <span style='color:#111;'> 919B </span>","children":null,"spread":false},{"title":"goroutine.go <span style='color:#111;'> 1.09KB </span>","children":null,"spread":false},{"title":"workerpool.go <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"sqlparser.go <span style='color:#111;'> 4.49KB </span>","children":null,"spread":false},{"title":"oracle.go <span style='color:#111;'> 974B </span>","children":null,"spread":false}],"spread":false},{"title":"cmd","children":[{"title":"main.go <span style='color:#111;'> 1.63KB </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":true}]

评论信息

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明