mysql快速比对数据库对象结构差异工具-java版

上传者: gzt19881123 | 上传时间: 2019-12-21 19:49:37 | 文件大小: 15.08MB | 文件类型: zip
!!!!!!!基于JDK1.8编写的java代码 相比之前的比对工具性能更加快速,直接运行java工程中的代码即可比对 1. 两个 MYSQL 数据库对象结构比对工具 (比如:本地测试库、远程运维库表结构、表中列等对比) 2. 比对结果导出EXCEL 存放于 “工程根目录”/export/ 目录下 3. 比对的对象包括 表、表列、表索引、表分区差异、触发器代码差异、存储过程代码差异,函数代码差异 和 对象是否存在等信息 4. 运行 cn.guzt.test.AppTest 中的 test方法即可(设置你的JDBC信息) 一般2秒左右即可出比对结果 5. 工程所需的jar 在 lib目录下

文件下载

资源详情

[{"title":"( 45 个子文件 15.08MB ) mysql快速比对数据库对象结构差异工具-java版","children":[{"title":"mysqldiff-master","children":[{"title":"src","children":[{"title":"cn","children":[{"title":"guzt","children":[{"title":"diff","children":[{"title":"properties","children":[{"title":"DbObjType.java <span style='color:#111;'> 130B </span>","children":null,"spread":false},{"title":"Constant.java <span style='color:#111;'> 3.39KB </span>","children":null,"spread":false},{"title":"ResultObj.java <span style='color:#111;'> 659B </span>","children":null,"spread":false}],"spread":true},{"title":"service","children":[{"title":"DiffService.java <span style='color:#111;'> 6.09KB </span>","children":null,"spread":false},{"title":"bean","children":[{"title":"DiffPrepareBean.java <span style='color:#111;'> 1.41KB </span>","children":null,"spread":false},{"title":"DiffBean.java <span style='color:#111;'> 1.10KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"action","children":[{"title":"DiffAction.java <span style='color:#111;'> 4.84KB </span>","children":null,"spread":false}],"spread":true},{"title":"mapper","children":[{"title":"MysqlMapper.xml <span style='color:#111;'> 2.44KB </span>","children":null,"spread":false},{"title":"MysqlMapper.java <span style='color:#111;'> 668B </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"export","children":[{"title":"ExportUtil.java <span style='color:#111;'> 6.90KB </span>","children":null,"spread":false}],"spread":true},{"title":"mysql","children":[{"title":"CodeUtil.java <span style='color:#111;'> 12.86KB </span>","children":null,"spread":false},{"title":"impl","children":[{"title":"ColumnPrepareService.java <span style='color:#111;'> 1.20KB </span>","children":null,"spread":false},{"title":"TablePrepareService.java <span style='color:#111;'> 1.31KB </span>","children":null,"spread":false},{"title":"IndexPrepareService.java <span style='color:#111;'> 1.19KB </span>","children":null,"spread":false},{"title":"FunctionPrepareService.java <span style='color:#111;'> 1.21KB </span>","children":null,"spread":false},{"title":"ProcedurePrepareService.java <span style='color:#111;'> 1.22KB </span>","children":null,"spread":false},{"title":"PartitionPrepareService.java <span style='color:#111;'> 1.22KB </span>","children":null,"spread":false},{"title":"TriggerPrepareService.java <span style='color:#111;'> 1.21KB </span>","children":null,"spread":false}],"spread":true},{"title":"AbstractPrepare.java <span style='color:#111;'> 1.77KB </span>","children":null,"spread":false}],"spread":true},{"title":"mybatis","children":[{"title":"MySqlSessionFactory.java <span style='color:#111;'> 2.74KB </span>","children":null,"spread":false},{"title":"bean","children":[{"title":"DbProperties.java <span style='color:#111;'> 1.99KB </span>","children":null,"spread":false}],"spread":false},{"title":"MySqlDataSourceFactory.java <span style='color:#111;'> 663B </span>","children":null,"spread":false}],"spread":true},{"title":"reflect","children":[{"title":"ReflectUtil.java <span style='color:#111;'> 2.38KB </span>","children":null,"spread":false},{"title":"DiffPrepareMarker.java <span style='color:#111;'> 401B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"test","children":[{"title":"AppTest.java <span style='color:#111;'> 1.94KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"log4j.properties <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"Main.java <span style='color:#111;'> 308B </span>","children":null,"spread":false}],"spread":true},{"title":"lib","children":[{"title":"poi-scratchpad-3.14-20160307.jar <span style='color:#111;'> 1.26MB </span>","children":null,"spread":false},{"title":"mysql-connector-java-5.1.39.jar <span style='color:#111;'> 966.30KB </span>","children":null,"spread":false},{"title":"commons-lang3-3.4.jar <span style='color:#111;'> 424.49KB </span>","children":null,"spread":false},{"title":"mybatis-3.4.5.jar <span style='color:#111;'> 1.55MB </span>","children":null,"spread":false},{"title":"fastjson-1.2.29.jar <span style='color:#111;'> 449.91KB </span>","children":null,"spread":false},{"title":"poi-ooxml-3.14-20160307.jar <span style='color:#111;'> 1.23MB </span>","children":null,"spread":false},{"title":"xmlbeans-2.6.0.jar <span style='color:#111;'> 2.60MB </span>","children":null,"spread":false},{"title":"log4j-1.2.15.jar <span style='color:#111;'> 382.65KB </span>","children":null,"spread":false},{"title":"curvesapi-1.03.jar <span style='color:#111;'> 90.08KB </span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.14-20160307.jar <span style='color:#111;'> 5.65MB </span>","children":null,"spread":false},{"title":"commons-io-1.4.jar <span style='color:#111;'> 106.49KB </span>","children":null,"spread":false},{"title":"poi-excelant-3.14-20160307.jar <span style='color:#111;'> 29.85KB </span>","children":null,"spread":false},{"title":"poi-3.14-20160307.jar <span style='color:#111;'> 2.41MB </span>","children":null,"spread":false},{"title":"poi-examples-3.14-20160307.jar <span style='color:#111;'> 332.11KB </span>","children":null,"spread":false}],"spread":false},{"title":"ReadMe.txt <span style='color:#111;'> 393B </span>","children":null,"spread":false},{"title":"mysqldiff.iml <span style='color:#111;'> 3.91KB </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 563B </span>","children":null,"spread":false},{"title":".gitignore <span style='color:#111;'> 12B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • blue6626 :
    多数据库差异对比分析必备
    2020-08-14
  • gavin_xzw :
    还行吧, 可以参考
    2020-08-05
  • lijingxin0311 :
    数据库唯一标识是什么呢
    2019-11-13
  • YaphetQZ :
    很好,完美可行
    2018-12-19
  • Javatwx :
    SELECT 1 AS COL FROM DUAL 这个虚拟表都没有会报错的
    2018-06-01

免责申明

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