Menu

dbmstools-0.4.4 released

The final release of version 0.4.4 of dbmstools is now available.

dbmstools is a set of utilities for software developers who work with databases. It understands database schemas (tables, sequences, views etc.) and DBMSs (Database Management Systems, e.g. Oracle, Postgres).

dbmstools is mainly intended for application developers who need to support schemas on more than one DBMS, or those who want to migrate a schema (possibly including data) from one DBMS to another. It also generates spiffy documentation for your schema, and makes testing easier, among other things. The focus is strictly on tools that: operate from the command line; can be integrated into software build systems; and play nicely with source control systems.

You can download the new release from http://sourceforge.net/project/showfiles.php?group_id=165690 , or check out the home page at http://dbmstools.sourceforge.net/ .

The major change since version 0.4.3 is the addition of support for runtime variables. This allows generation of schema variants based on any conditions you choose - particularly useful for things like including different indexes on your master and slave schemas for replication. Variables can also be inserted in documentation for any element.

Other changes include explicit support for column defaults and auto-increment columns, 'tiny' and 'boolean' data types, as well as sequences on the Hypersonic DBMS. MySQL support has been improved, particularly in generating upgrade scripts with deltaddl. And there has been the usual slew of small bug fixes and improvements.

Changes since 0.4.4-rc2 were minimal - support for self-referential tables/foreign keys, documentation improvements, and improvements to some error messages.

Thanks to Lee Andrew and Amit Joshi for assistance and suggesions for this release.

Cheers ................. JD

Posted by John Dickson 2007-12-01

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.