mykit-db-sync:mykit中分离出的强大的数据库同步工具——mykit-db-sync。 基于java开发的功能强大、配置灵活的数据库同步工具，目前支持MySQL、SQL Server和Oracle数据库的同步，在实际应用场景中，我们经常需要定期将一个数据库的数据同步到另外一个数据库中，常见的一种做法是将源数据库的数据dump为sql文件，然后到目标数据库执行sql文件完成数据库的导入，但是这种方法至少存在以下问题： - 需要手工操作，效率低 - 当涉及数据表较多时，容易遗漏、出错 -

[{"title":"（ 47 个子文件 2.57MB ） mykit-db-sync:mykit中分离出的强大的数据库同步工具——mykit-db-sync。 基于java开发的功能强大、配置灵活的数据库同步工具，目前支持MySQL、SQL Server和Oracle数据库的同步，在实际应用场景中，我们经常需要定期将一个数据库的数据同步到另外一个数据库中，常见的一种做法是将源数据库的数据dump为sql文件，然后到目标数据库执行sql文件完成数据库的导入，但是这种方法至少存在以下问题： - 需要手工操作，效率低 - 当涉及数据表较多时，容易遗漏、出错 -","children":[{"title":"mykit-db-sync-master","children":[{"title":".gitignore <span style='color:#111;'> 254B </span>","children":null,"spread":false},{"title":"mykit-db-common","children":[{"title":"src","children":[{"title":"main","children":[{"title":"java","children":[{"title":"io","children":[{"title":"mykit","children":[{"title":"db","children":[{"title":"common","children":[{"title":"entity","children":[{"title":"BaseJobInfo.java <span style='color:#111;'> 1.22KB </span>","children":null,"spread":false},{"title":"BaseDBInfo.java <span style='color:#111;'> 1.86KB </span>","children":null,"spread":false}],"spread":true},{"title":"exception","children":[{"title":"MykitDbSyncException.java <span style='color:#111;'> 1.63KB </span>","children":null,"spread":false}],"spread":true},{"title":"build","children":[{"title":"BaseBuilder.java <span style='color:#111;'> 1.97KB </span>","children":null,"spread":false}],"spread":true},{"title":"db","children":[{"title":"DbConnection.java <span style='color:#111;'> 1.77KB </span>","children":null,"spread":false},{"title":"DataSourceFactory.java <span style='color:#111;'> 3.23KB </span>","children":null,"spread":false}],"spread":true},{"title":"utils","children":[{"title":"StringUtils.java <span style='color:#111;'> 879B </span>","children":null,"spread":false},{"title":"CollectionUtils.java <span style='color:#111;'> 911B </span>","children":null,"spread":false},{"title":"DateUtils.java <span style='color:#111;'> 27.61KB </span>","children":null,"spread":false},{"title":"Tool.java <span style='color:#111;'> 1.20KB </span>","children":null,"spread":false},{"title":"MatcherUtils.java <span style='color:#111;'> 1.83KB </span>","children":null,"spread":false}],"spread":false},{"title":"constants","children":[{"title":"MykitDbSyncConstants.java <span style='color:#111;'> 2.88KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"pom.xml <span style='color:#111;'> 510B </span>","children":null,"spread":false}],"spread":true},{"title":"LICENSE <span style='color:#111;'> 11.09KB </span>","children":null,"spread":false},{"title":"mykit-db-oracle","children":[{"title":"jobs.xml <span style='color:#111;'> 972B </span>","children":null,"spread":false},{"title":"src","children":[{"title":"main","children":[{"title":"resources","children":[{"title":"log4j.properties <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false}],"spread":true},{"title":"java","children":[{"title":"io","children":[{"title":"mykit","children":[{"title":"db","children":[{"title":"oracle","children":[{"title":"entity","children":[{"title":"DBInfo.java <span style='color:#111;'> 1.79KB </span>","children":null,"spread":false},{"title":"JobInfo.java <span style='color:#111;'> 900B </span>","children":null,"spread":false}],"spread":false},{"title":"build","children":[{"title":"DBSyncBuilder.java <span style='color:#111;'> 4.95KB </span>","children":null,"spread":false}],"spread":false},{"title":"Main.java <span style='color:#111;'> 1.42KB </span>","children":null,"spread":false},{"title":"task","children":[{"title":"JobTask.java <span style='color:#111;'> 8.18KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"pom.xml <span style='color:#111;'> 1007B </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 2.84KB </span>","children":null,"spread":false},{"title":"jar","children":[{"title":"ojdbc6.jar <span style='color:#111;'> 2.61MB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"pom.xml <span style='color:#111;'> 4.69KB </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 2.05KB </span>","children":null,"spread":false},{"title":"NOTICE <span style='color:#111;'> 3.71KB </span>","children":null,"spread":false},{"title":"mykit-db-transfer","children":[{"title":"jobs.xml <span style='color:#111;'> 1.23KB </span>","children":null,"spread":false},{"title":"src","children":[{"title":"main","children":[{"title":"resources","children":[{"title":"log4j.properties <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false}],"spread":true},{"title":"java","children":[{"title":"io.mykit.db.transfer","children":[{"title":"entity","children":[{"title":"DBInfo.java <span style='color:#111;'> 903B </span>","children":null,"spread":false},{"title":"JobInfo.java <span style='color:#111;'> 2.26KB </span>","children":null,"spread":false}],"spread":false},{"title":"factory","children":[{"title":"DBSyncFactory.java <span style='color:#111;'> 1.70KB </span>","children":null,"spread":false}],"spread":false},{"title":"sync","children":[{"title":"impl","children":[{"title":"AbstractDBSync.java <span style='color:#111;'> 1.92KB </span>","children":null,"spread":false},{"title":"SQLServerSync.java <span style='color:#111;'> 3.28KB </span>","children":null,"spread":false},{"title":"OracleSync.java <span style='color:#111;'> 5.54KB </span>","children":null,"spread":false},{"title":"MySQLSync.java <span style='color:#111;'> 4.57KB </span>","children":null,"spread":false}],"spread":false},{"title":"DBSync.java <span style='color:#111;'> 1.36KB </span>","children":null,"spread":false}],"spread":false},{"title":"build","children":[{"title":"DBSyncBuilder.java <span style='color:#111;'> 5.05KB </span>","children":null,"spread":false}],"spread":false},{"title":"Main.java <span style='color:#111;'> 1.41KB </span>","children":null,"spread":false},{"title":"task","children":[{"title":"JobTask.java <span style='color:#111;'> 3.82KB </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":true}],"spread":true},{"title":"test","children":[{"title":"java","children":[{"title":"io","children":[{"title":"mykit","children":[{"title":"db","children":[{"title":"transfer","children":[{"title":"test","children":[{"title":"MykitTransferTest.java <span style='color:#111;'> 1.11KB </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"mysql_oracle_jobs.xml <span style='color:#111;'> 1.22KB </span>","children":null,"spread":false},{"title":"oracle_mysql_jobs.xml <span style='color:#111;'> 1.18KB </span>","children":null,"spread":false},{"title":"pom.xml <span style='color:#111;'> 1.45KB </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 7.24KB </span>","children":null,"spread":false},{"title":"mysql_mysql_jobs.xml <span style='color:#111;'> 1.23KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]