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.
That's a complex topic and there is no easy answer. In short:
There is a book, of course, and it is pretty good: Refactoring Databases