数据库结构维护工具 dzo
本文导语: Dzo 是一个数据库的小工具,用以帮助维护不同的数据库结构,当前支持 MySQL 和 Oracle 、SQLServer。 The goal of dzo is to treat applications database objects the same way the applications source code is treated, with respect to development, revision control, and dep...
Dzo 是一个数据库的小工具,用以帮助维护不同的数据库结构,当前支持 MySQL 和 Oracle 、SQLServer。
The goal of dzo is to treat applications database objects the same way the applications source code is treated, with respect to development, revision control, and deployment. Dzo uses a text file that contains native create statements for all database objects and compares them against the actual database-schema. As a result, dzo creates the SQL statements needed to update the database schema (or you can let dzo execute the SQL statements directly). If your application lives in a Tomcat or JBoss container, dzo has a servlet that controls the deployment process, undeploys the old application, inspect and execute the needed database changes, and finally deploys the new application. Dzo currently works with MySQL and Oracle.