Wow, it’s been a while. If you’re interested in good links follow me on Twitter: http://twitter.com/anderssv . I usually update there these days.
My talk on “Agile deployment” got accepted for JavaZone this year! I’m extremely happy, but a bit scared too. I’ll be talking about rolling out changes in a controlled manner, and one of the things that are usually neglected in this scenario is the database side. I’ll cover stuff like packaging and deploy of the application too, but that’s probably the area where I know the least. The database side of things are really sort of my expertise.
I have written some blog posts on this already, and in relation to the talk and things at work I did a quick search for Java migration tools. DBDeploy I have used earlier, but there are now a couple of other contenders. Here’s my list so far of tools that work on sql deltas that can be checked into SCM:
- DBDeploy – Tried, few features but works well. Ant based.
- DbMaintain – Probably has the most features. Ant based.
- c5-db-migration – Interesting alternative, similar to DBDeploy. Maven based.
- scala-migrations – Based on the Ruby on Rails migrations. Interesting take.
- migrate4j – Similar to Scala Migrations, but implemented in Java.
- Bering – Similar to Scala Migrations, and looks a lot like Migrate4J
I’ll definitely be looking into DbMaintain and c5-db-migration soon. DbMaintain looks promising, or I migh just contribute to DBDeploy some features. I’ll let you know how it went.
(updated with scala-migrations, bering and migrate4j after first post)