Dzo A database utility which helps to maintain database schemas
Download

Dzo Ranking & Summary

Dzo Tags

database frontend database frontend administrative frontend database schemas schemas

Dzo Description

A database utility which helps to maintain database schemas The Dzo software 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. Requirements: · Java 2 Standard Edition Runtime Environment What's New in This Release: · Drop and recreate foreign keys, primary keys, index when needed (for sqlserver when a column changes, for oracle when a index that primary key is depending on is changed). · Fixed bug when fetching metadata for columns for sqlserver. · Add unique-constraint for oracle. · Dont do "create table" when the table only exists implicitly (because there are reference-data or an index on the table).

Dzo Related Software