java库来维护数据库结构 [英] java library to maintain database structure

问题描述

我的应用程序总是在开发，所以偶尔 - 当版本升级时 - 一些表需要被创建/改变/删除，一些数据被修改等等。通常一些sql代码需要执行。

My application is always developing, so occasionally - when the version upgrades - some tables need to be created/altered/deleted, some data modified, etc. Generally some sql code needs to be executed.

有一个Java库可用于保持我的数据库结构更新（通过分析类似 db structure version 信息并执行自定义sql以便代码从一个版本更新到另一个版本）？

Is there a Java library that can be used to keep my database structure up to date (by analyzing something like "db structure version" information and executing custom sql to code to update from one version to another)?

一些基本动作（如添加/删除列）可以使用最小配置，即名称/类型和没有sql代码。

Also it would be great to have some basic actions (like add/remove column) ready to use with minimal configuration, ie name/type and no sql code.

推荐答案

尝试 DBDeploy 。虽然我没有使用它在过去，它听起来像这个项目将有助于你的情况。 DBDeploy是一个数据库重构管理器：

Try DBDeploy. Although I haven't used it in the past, it sounds like this project would help in your case. DBDeploy is a database refactoring manager that:

自动化建立
的过程哪个数据库重构需要
在
命令中将特定数据库迁移到特定的
构建。

"Automates the process of establishing which database refactorings need to be run against a specific database in order to migrate it to a particular build."

包括Ant和Maven。

It is known to integrate with both Ant and Maven.

这篇关于java库来维护数据库结构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！