Win a copy of Secure Financial Transactions with Ansible, Terraform, and OpenSCAP this week in the Cloud/Virtualization forum!
  • 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
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Rob Spoor
  • Henry Wong
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh
  • Jj Roberts

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.
 
The glass is neither half full or half empty. It is too big. But this tiny ad is just right:
SKIP - a book about connecting industrious people with elderly land owners
https://coderanch.com/t/skip-book
reply
    Bookmark Topic Watch Topic
  • New Topic