Sundog has announced the opening of the early access program for its Database Refactoring Tool (SDRT)
, a DBMS-independent tool to ease database development in an agile environment.
The core of the SDRT is the migrator, which eases the tracking and application of database changes. The migrator is built on 3 main features:
- All changes are stored in your source control system along with the rest of your code in a format that works well with branching and merging
- Each change has a easy to generate, yet unique across time and space identifier
- Each database knows what changes have been applied to it and which have not so it can be easily updated to match what the current version of the code expects
Sundog says the SDRT's database-system independence, and that it "understands" what changes need to be made to any version of your database schema, sets it apart from other tools.
The SDRT can be run as a command line tool, an Ant task, or as a servlet context listener which allows your schema to be updated automatically whenever your site is re-deployed.
The initial release is focused around the migrator, but future features planned for the final release include:
- Additional refactorings
- Refactoring GUI IDE Plug-in
- Stored procedures/Views support
- Extracting sample data from a larger dataset
- Generating testing data for tables
- DB unit testing harness
- .Net support
- SQL editor
- Support for additional DBMSs
- Database diagram generation