Thanks a lot Paul for the information.
I found some very useful information about Liquibase over here
http://www.oneadam.net/?p=27
I am not sure, how efficiently this tool will work, if their are drastic and huge changes in the database schema. ( I am referring to changes like: Say an entity bean is modified to drop @ManyToMany relationship and add a new @OneToMany relationship etc.)
For some reason I am getting inclined towards using Logical Data Export/Import.
Pros: No risk of loosing data or corrupting production data.
Cons:Lot of efforts will be wasted, in modifying/implementing the Import logic every time the schema is modified.
It will be very helpful if you can add some more information:
1) I am not sure how robust the Liquibase tool is at moment. Have you seen use of Liquibase in Production Applications?
2) Can this tool handle complex database schema changes?
Best Regards
Suyog
[Message sent by forum member 'suyogbarve' (suyogbarve)]
http://forums.java.net/jive/thread.jspa?messageID=338119