这是一个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();
}
评论