Java library maintains database structure

My application is always developed, so occasionally - when the version is upgraded - some tables need to be created / changed / deleted, some data modification, etc Generally speaking, some SQL code needs to be executed

Is there a Java library that can be used to keep the database structure updated (by analyzing the "database structure version" information and executing custom SQL code to update from one version to another)?

In addition, some basic operations (such as adding / deleting columns) can use the least configuration, that is, name / type and no SQL code is good

Solution

Try dbdeploy Although I haven't used it before, it sounds like this project will help your situation Dbdeploy is a database refactoring manager that:

Known to integrate with ant and Maven