> > As for ongoing maintenance (upgrading the database, running scripts, etc) > I've recently discovered liquibase and it is really rather nice for dealing > with different databases without rewriting lots of SQL by hand. >
I'm working on a migrations API for Cayenne to do this. It's actually done, I just need to write the unit tests. I hoping to contribute it. It provides an API for creating changing the DB schema over time and uses the MergerFactory and MergerTokens along with the DbAdapter to do the work. John