JarCasting
JarCasting JarCasting

Beangle DB Transport

The Beangle Database Utilities.

License

License
GroupId

GroupId

org.beangle.db
ArtifactId

ArtifactId

beangle-db-transport
Last Version

Last Version

0.0.10
Release Date

Release Date
Type

Type

jar
Description

Description

Beangle DB Transport
The Beangle Database Utilities.
Project Organization

Project Organization

The Beangle Software

Download beangle-db-transport

Filename Size
beangle-db-transport-0.0.10.pom
beangle-db-transport-0.0.10.jar 64 KB
beangle-db-transport-0.0.10-sources.jar 16 KB
beangle-db-transport-0.0.10-javadoc.jar 1 MB
Browse

How to add to project

<!-- https://jarcasting.com/artifacts/org.beangle.db/beangle-db-transport/ -->
<dependency>
    <groupId>org.beangle.db</groupId>
    <artifactId>beangle-db-transport</artifactId>
    <version>0.0.10</version>
</dependency>
// https://jarcasting.com/artifacts/org.beangle.db/beangle-db-transport/
implementation 'org.beangle.db:beangle-db-transport:0.0.10'
// https://jarcasting.com/artifacts/org.beangle.db/beangle-db-transport/
implementation ("org.beangle.db:beangle-db-transport:0.0.10")
'org.beangle.db:beangle-db-transport:jar:0.0.10'
<dependency org="org.beangle.db" name="beangle-db-transport" rev="0.0.10">
  <artifact name="beangle-db-transport" type="jar" />
</dependency>
@Grapes(
@Grab(group='org.beangle.db', module='beangle-db-transport', version='0.0.10')
)
libraryDependencies += "org.beangle.db" % "beangle-db-transport" % "0.0.10"
[org.beangle.db/beangle-db-transport "0.0.10"]

Dependencies

compile (13)

Group / Artifact Type Version
org.postgresql : postgresql Optional jar 42.2.20
com.h2database : h2 jar 1.4.200
net.sourceforge.jtds : jtds Optional jar 1.3.1
com.oracle.database.jdbc : ojdbc11 Optional jar 21.1.0.0
com.oracle.database.nls : orai18n Optional jar 21.1.0.0
mysql : mysql-connector-java jar 8.0.24
com.microsoft.sqlserver : mssql-jdbc jar 9.2.1.jre11
com.zaxxer : HikariCP jar 4.0.3
org.slf4j : slf4j-api jar 2.0.0-alpha1
org.beangle.data : beangle-data-jdbc_2.13 jar 5.3.22
org.scala-lang : scala-library jar 2.13.5
org.scala-lang : scala-reflect jar 2.13.5
org.scala-lang.modules : scala-xml_2.13 jar 2.0.0-RC1

runtime (2)

Group / Artifact Type Version
ch.qos.logback : logback-core jar 1.3.0-alpha5
ch.qos.logback : logback-classic jar 1.3.0-alpha5

test (4)

Group / Artifact Type Version
org.scalatest : scalatest_2.13 jar 3.2.8
org.scalatestplus : junit-4-13_2.13 jar 3.2.8.0
junit : junit jar 4.13.2
org.mockito : mockito-core jar 3.9.0

Project Modules

There are no modules declared in this project.

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://github.com/beangle/db/tree/main/transport/src/main/scripts/transport.sh
chmod +x transport.sh
./transport.sh /path/to/your.xml
org.beangle.db

Beangle

Versions

Version
0.0.10
0.0.9