• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Scott Selikoff
Bartenders:
  • Piet Souris
  • Jj Roberts
  • fred rosenberger

Announcing dbTamer 0.2

 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic