Skip to content
体华 edited this page Apr 8, 2015 · 1 revision

使用beangle-data-conversion进行数据库转换,可以将数据、约束、索引、序列进行转换到目标数据库上。 例如按照如下的配置保存到sample.xml文件上,将oracle数据库中的数据转换到postgresql上。

<?xml version="1.0" encoding="UTF-8"?>
<conversion maxthreads="10">
  <source>
    <db>
      <dialect>org.beangle.data.jdbc.dialect.OracleDialect
      </dialect>
      <driver>oracle.jdbc.driver.OracleDriver</driver>
      <url>jdbc:oracle:thin:@//192.168.100.1:1521/public</url>
      <user>user</user>
      <password>password</password>
    </db>
    <tables lowcase="true" index="true" constraint="true">
      <includes>*</includes>
      <excludes></excludes>
    </tables>
    <sequences>
      <includes>*</includes>
    </sequences>
  </source>

  <target>
    <db>
      <dialect>org.beangle.data.jdbc.dialect.PostgreSQLDialect</dialect>
      <driver>org.postgresql.Driver</driver>
      <url>jdbc:postgresql://192.168.100.2:5432/urp</url>
      <user>user</user>
      <password>password</password>
      <schema>schema</schema>
    </db>
  </target>
</conversion>

然后使用java -cp lib/* org.beangle.db.conversion.Reactor$ sample.xml即可

Clone this wiki locally