Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Manage database versioning

 
avihai marchiano
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey,

I know that this question not directly relevant to this forum, but there are a lot of experience developers here with knowledge on this issue.
We are working with JPA.
We don�t have customers yet, and hibernate generate the schema for us.(auto create).

From next week we will give the first delivery to QA and we can�t drop and crate the database for each delivery.
We need to give patches that will upgrade the database without lost all the data.

How you guys handle this? What is your experience with this? What about refactoring in the hibernate classes?

Thank you
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, Hibernate can also just update the tables for you besides auto-create. I haven't had much experience using this feature, and in most cases would wrote SQL scripts to update the tables and run them directly on the database.

Mark
 
avihai marchiano
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I dont think that you can count on the hibernate update.

Do you get help from tools in order to generate the alters and view the changes in the database schema?

Thank you,
Happy new year.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by avihai marchiano:
I dont think that you can count on the hibernate update.

Do you get help from tools in order to generate the alters and view the changes in the database schema?

Thank you,
Happy new year.



Well, personally, and it is personal. But I would write them from scratch. I am sure tools can help, but back in the day, when I would need to do that, I would write my alters from scratch in sql files and run them from sqlplus.

Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic