How to Avoid Using Sleep Mode Update

Question

I use Hibernate in my daily programming tasks, and I find this very good. In particular, I like the way it manages the updating of the circuit during development, saving me a lot of headaches.

In any case, they wrote in the documents that this is not recommended in the production environment, of course. Therefore, when I update the application on the production server, what can be the standard way for the industry? I thought about creating an automatic installation procedure that deletes the contents of the database (mostly backups), and then causes the hibernation scheme to be updated from the code, then runs several tests on request, etc. Anyway, are there any tools around that will do this automatically and be well tested?

Speak! :)

Thank.

Answer 1

See Strategies to tackle the ever-changing requirements for MySQL schemas? for a similar question and its answer.

, , , SQL / .

Answer 2

Liquibase. , , . Hibernate.

Answer 3

, . Hibernate , ( , ).

Obviously, you need to test your application to ensure that Hibernate does the right job when upgrading from one version to another, but the same applies to any other software aspect.

You should also know what automatic updating can do (for example, create new tables, add new indexes) and that it cannot (for example, delete tables, remove restrictions). Missing bits can easily be done using raw JDBC, again, without testing.