1 Reply Latest reply on Nov 3, 2010 9:51 PM by Nikolay Elenkov

    Best practice to propagate DB scheme update into production

    Vasilii Lukoyanov Newbie

      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