Hi everyone.

My question is a bit off topic and not directly related to Seam, but I just wanna ask you, fellow Seam developers, about your practices to apply DB scheme changes from development environment into production.

I've got a website up and running (developed using Seam btw) in production for quite a while and now I want to introduce some new features that would involve scheme changes. And of course I want to migrate all existing data. Also I want to be able to do it in a smooth and most automated way, and I want to maintain all changes I've done somewhere in my SCM and be able to rollback them if I needed.

So is there any good tools to do that, and what's your experience and practices for that kind of task?

I've heard of a tool named liquibase, and I'm trying to evaluate it now. So if anyone uses that tool, please advice whether or not its worth using it.

------

Templates Gallery