Beangle DB Conversion

The Beangle Database Utilities.

License	GNU Lesser General Public License
GroupId	org.beangle.db
ArtifactId	beangle-db-conversion
Last Version	0.0.1
Release Date	Dec 20, 2013
Type	jar
Description	Beangle DB Conversion The Beangle Database Utilities.
Project Organization	The Beangle Software

Download beangle-db-conversion

Filename	Size
beangle-db-conversion-0.0.1.pom
beangle-db-conversion-0.0.1.jar	61 KB
beangle-db-conversion-0.0.1-sources.jar	14 KB
beangle-db-conversion-0.0.1-javadoc.jar	405 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/org.beangle.db/beangle-db-conversion/ -->
<dependency>
    <groupId>org.beangle.db</groupId>
    <artifactId>beangle-db-conversion</artifactId>
    <version>0.0.1</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/org.beangle.db/beangle-db-conversion/
implementation 'org.beangle.db:beangle-db-conversion:0.0.1'

Gradle Kotlin

// https://jarcasting.com/artifacts/org.beangle.db/beangle-db-conversion/
implementation ("org.beangle.db:beangle-db-conversion:0.0.1")

Apache Buildr

'org.beangle.db:beangle-db-conversion:jar:0.0.1'

Apache Ivy

<dependency org="org.beangle.db" name="beangle-db-conversion" rev="0.0.1">
  <artifact name="beangle-db-conversion" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='org.beangle.db', module='beangle-db-conversion', version='0.0.1')
)

Scala SBT

libraryDependencies += "org.beangle.db" % "beangle-db-conversion" % "0.0.1"

Leiningen

[org.beangle.db/beangle-db-conversion "0.0.1"]

Dependencies

compile (5)

Group / Artifact	Type	Version
org.postgresql : postgresql Optional	jar	9.3-1102-jdbc4
net.sourceforge.jtds : jtds Optional	jar	1.3.1
commons-dbcp : commons-dbcp	jar	1.4
org.slf4j : slf4j-api	jar	1.7.7
org.beangle.data : beangle-data-jdbc	jar	4.2.2

runtime (2)

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

test (3)

Group / Artifact	Type	Version
org.scalatest : scalatest_2.11	jar	2.2.4
junit : junit	jar	4.12
org.mockito : mockito-core	jar	1.10.8

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.1 Dec 20, 2013