• 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:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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.
 
Hug your destiny! And hug this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic