aspose file tools*
The moose likes Blatant Advertising and the fly likes Announcing dbTamer 0.2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Other » Blatant Advertising
Bookmark "Announcing dbTamer 0.2" Watch "Announcing dbTamer 0.2" New topic
Author

Announcing dbTamer 0.2

David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

http://sourceforge.net/projects/dbtamer/

This is the initial 'functional release', but while it has most of the internal heavy lifting and glue, it is largely untested and is more useful via the API thatn the command line or ANT task. See the tests packaged in the source for an example of use.

What is DbTamer?

It is designed to solve several specific DB problems.
* Firstly it can read the schema and data from the source DB and copy it to a destination. While some databases provide this feature, DbTamer is able to migrate between different database types eg from Oracle to MaxDb (or it will once I have completed the dialect specific functionality)
* It can also export to a file rather than a physical DB, although the destination DB can still be a different type from the source DB and the schema and data SQL will reflect these differences. When exporting a source DB to a file of the same type, it effectively reverse engineers the database.
* In the case where the source and destination schemas are defined, it can still migrate data and can allow for schema differences between the source and destination. eg columns added, dropped, renamed or modified.

The next step is to improve the ANT interface (see the comments in the Task), do a heap of debugging, expand and test the DB specific code and generally make ready for a 1.0 release.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Announcing dbTamer 0.2