dzo數(shù)據(jù)庫結(jié)構(gòu)維護工具

Dzo 是一個數(shù)據(jù)庫的小工具，用以幫助維護不同的數(shù)據(jù)庫結(jié)構(gòu)，當(dāng)前支持 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.