Beangle DB Conversion

The Beangle Database Utilities.

License	GNU Lesser General Public License
GroupId	org.beangle.db
ArtifactId	beangle-db-conversion_2.12
Last Version	0.0.5
Release Date	Oct 3, 2018
Type	jar
Description	Beangle DB Conversion The Beangle Database Utilities.
Project Organization	The Beangle Software

Download beangle-db-conversion_2.12

Filename	Size
beangle-db-conversion_2.12-0.0.5.pom
beangle-db-conversion_2.12-0.0.5.jar	47 KB
beangle-db-conversion_2.12-0.0.5-sources.jar	12 KB
beangle-db-conversion_2.12-0.0.5-javadoc.jar	403 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/org.beangle.db/beangle-db-conversion_2.12/ -->
<dependency>
    <groupId>org.beangle.db</groupId>
    <artifactId>beangle-db-conversion_2.12</artifactId>
    <version>0.0.5</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/org.beangle.db/beangle-db-conversion_2.12/
implementation 'org.beangle.db:beangle-db-conversion_2.12:0.0.5'

Gradle Kotlin

// https://jarcasting.com/artifacts/org.beangle.db/beangle-db-conversion_2.12/
implementation ("org.beangle.db:beangle-db-conversion_2.12:0.0.5")

Apache Buildr

'org.beangle.db:beangle-db-conversion_2.12:jar:0.0.5'

Apache Ivy

<dependency org="org.beangle.db" name="beangle-db-conversion_2.12" rev="0.0.5">
  <artifact name="beangle-db-conversion_2.12" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='org.beangle.db', module='beangle-db-conversion_2.12', version='0.0.5')
)

Scala SBT

libraryDependencies += "org.beangle.db" % "beangle-db-conversion_2.12" % "0.0.5"

Leiningen

[org.beangle.db/beangle-db-conversion_2.12 "0.0.5"]

Dependencies

compile (5)

Group / Artifact	Type	Version
org.postgresql : postgresql Optional	jar	42.2.5
net.sourceforge.jtds : jtds Optional	jar	1.3.1
com.zaxxer : HikariCP	jar	2.4.7
org.slf4j : slf4j-api	jar	1.7.25
org.beangle.data : beangle-data-jdbc_2.12	jar	5.0.8

provided (2)

Group / Artifact	Type	Version
org.scala-lang : scala-library	jar	2.12.7
org.scala-lang : scala-reflect	jar	2.12.7

runtime (2)

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

test (3)

Group / Artifact	Type	Version
org.scalatest : scalatest_2.12	jar	3.0.5
junit : junit	jar	4.12
org.mockito : mockito-core	jar	2.22.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

Beangle

Versions

Version
0.0.5 Oct 3, 2018
0.0.4 Aug 26, 2016
0.0.3 Jun 9, 2016
0.0.2 Mar 10, 2016