beangle / db   0.0.19

GNU Lesser General Public License v3.0 only GitHub

Beangle Database Development Utility

Scala versions: 3.x 2.13 2.12

Database Utility

Beangle Database Development Utility

Transport data from db1 to db2

Edit config file(oracle to postgresql etc.)

<?xml version="1.0" encoding="UTF-8"?>
<transport maxthreads="10">
  <source>
    <db>
      <driver>oracle</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>
  </source>

  <target>
    <db>
      <driver>postgresql</driver>
      <url>jdbc:postgresql://192.168.100.2:5432/urp</url>
      <user>user</user>
      <password>password</password>
      <schema>schema</schema>
    </db>
  </target>
  <actions>
     <before>
       <sql file="/path/to/sql/file/do/something/in/oracle.sql"
     </before>
     <after>
       <sql file="/path/to/sql/file/do/something/in/postgresql.sql"/>
     </after>
  </actions>
</transport>

Download scripts

wget https://raw.githubusercontent.com/beangle/db/main/transport/src/main/scripts/transport.sh
chmod +x transport.sh
./transport.sh /path/to/your.xml