mysql迁移工具下载_MySQL 迁移工具

MySQL迁移工具

支持模块

Table

View

Function

Procedure

Trigger

使用方法

引入jar包:

cn.codeforfun

mysql-migrate

1.0.0

测试方法:

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 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();

}

源码地址