lmmtMySQL 迁移工具
这是一个MySQL迁移工具。
支持模块
- Table
- View
- Function
- Procedure
- Trigger
使用方法
引入jar包:
<dependency> <groupId>cn.codeforfun</groupId> <artifactId>mysql-migrate</artifactId> <version>1.0.0</version> </dependency>
测试方法:
import cn.codeforfun.migrate.core.diff.DiffResult; import cn.codeforfun.migrate.core.entity.DatabaseInfo; import org.junit.Test; import java.sql.SQLException; import java.util.List; private static final Integer FROM_PORT = 3306; private static final String FROM_HOST = "localhost"; private static final String FROM_USERNAME = "root"; private static final String FROM_PASSWORD = "root"; private static final String FROM_TABLE = "test_db"; private static final Integer TO_PORT = 3307; private static final String TO_HOST = "localhost"; private static final String TO_USERNAME = "root"; private static final String TO_PASSWORD = "root"; private static final String TO_TABLE = "test_db"; @Test public void diff() throws SQLException { DatabaseInfo from = new DatabaseInfo(FROM_HOST, FROM_PORT, FROM_TABLE, FROM_USERNAME, FROM_PASSWORD); DatabaseInfo to = new DatabaseInfo(TO_HOST, TO_PORT, TO_TABLE, TO_USERNAME, TO_PASSWORD); Migrate migrate = new Migrate().from(from).to(to); DiffResult diffResult = migrate.diff(); List<String> sqlList = diffResult.getSqlList(); for (String sql : sqlList) { System.out.println(sql); } } @Test public void update() throws SQLException { DatabaseInfo from = new DatabaseInfo(FROM_HOST, FROM_PORT, FROM_TABLE, FROM_USERNAME, FROM_PASSWORD); DatabaseInfo to = new DatabaseInfo(TO_HOST, TO_PORT, TO_TABLE, TO_USERNAME, TO_PASSWORD); Migrate migrate = new Migrate().from(from).to(to); migrate.update(); }
源码地址
评论
WindupJBoss 自动迁移工具
Windup是简化Java应用迁移的工具,Windup会分析应用工件(Java代码,JSPs和XML),生成强调需要改动区域的HTML报告。在线示例
WindupJBoss 自动迁移工具
0
Redis-Migrate-ToolRedis 集群迁移工具
Redis集群迁移工具,基于redis复制,快速,稳定。特点:快速。多线程。基于redis复制。实时迁移。迁移过程中,源集群不影响对外提供服务。异构迁移。支持Twemproxy集群,redisclus
Redis-Migrate-ToolRedis 集群迁移工具
0