oracle dumping / sql execution tool in java

From: armin walland <geschrei_at_gmx.at>
Date: Thu, 03 Jun 2004 23:03:47 GMT
Message-ID: <1086303827.107422_at_anterovipunen.underwater.own>


Hi dear group!

i have written a small jdbc based tool in java that may be used to dump one, some or all tables from an oracle database in different ways (INSERT statements, [postgres] COPY FROM STDIN statements or as tab-separated text) or execute sql commands.

also the tool can execute sql statements which it reads from stdin or from a file.
it may also be used interactively but there is no readline support or cmdline editing support yet. i will try to add that if a lot of people request it but for now i expect it to be used primarily in scripts but i may be wrong :)

the main benefits are the following:

.)there is no need for oracle client software installed to use it
.)the tool can be used to synchronize oracle to other dbs
.)the tool can be used to execute any DDL or DML on the remote db
.)there are no dependencies except a current jre and the thin ojdbc

	  driver

.)jdbc appears to be pretty fast and very stable
.)it is cross platform

the tool is called oradump and it is available from sourceforge at https://sourceforge.net/projects/oradump/

it is still in beta status so please do not use it in productive environments without a lot of testing. as i write this it is available as version 0.18 and i consider the current features as [kinda] stable. the license is GPL.
i would be very happy to receive any comments, ideas, bugreports... whatever and i hope this tool can be useful to some people.

best regards and enjoy, armin

-- 

my life, my universe, my everything
http://www.dtch.org
Received on Fri Jun 04 2004 - 01:03:47 CEST

Original text of this message