Dzo

Software Screenshot:
Dzo
Software Details:
Version: 3.1.0
Upload Date: 14 Apr 15
Developer: Ulf Naslund
Distribution Type: Freeware
Downloads: 25

Rating: nan/5 (Total Votes: 0)

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.

What is new in this release:

  • This version generate cross-references for foreign keys.
  • It will drop and recreate the unique index, unique constraint, and foreign key when reference data changes in a column involved in the object.
  • It handles the datatype bit when extracting reference data.
  • It handles date and time in the expression evaluator.
  • Maven goals XML and source handle schemas-attribute.

What is new in version 2.5.0:

  • Refactoring was done when traversing relations in jpa-annotated beans.
  • The names of maven and ant tags were changed from "url" to "jdbcUrl", from "driver" to "jdbcDriver", and from "file" to "source".
  • The attribute database was changed to dbType and is no longer mandatory.
  • A unique key is created when a Map or Set is used in jpa annotated ElementCollection.
  • The Swedish users' reference was removed, as it was outdated.
  • Dependencies were added to jpa-annotations and the supported and downloadable jdbc-drivers in maven-plugin.
  • The default directory in the WAR file for SQL source was changed to /META-INF.
  • Some minor bugs were fixed.

What is new in version 2.3.0:

  • The sort attribute was added in the #convert directive.
  • The refdata function was implemented to test against referencedata in #convert.
  • A bug when updating a schema comparing to another schema was fixed.
  • Mysqlbug was fixed when a table name differs in case only when a rename is done.
  • In the command line a file can be prefixed with "-cp:", which searches for the file in the classpath.
  • Table-content is automatically converted when JPA inheritance strategy changes.
  • The expression evaluator can now use public static functions and fields from Java classes.
  • Getopt was refactored.
  • A bug was fixed in the parser, which consumed hash characters ("#") that are not in a directive.

What is new in version 2.2.0:

  • You now can control how naming from Classes/fields to Tables/columns is done.
  • Support for HSQLDB was started, but is not finished yet.
  • The annotations @Embeddable, @MappedSuperclass, @EmbedId, @Inheritance @ManyToMany, @CollectionOfElements, @JoinTable, and @JoinColumns are handled when generating SQL from JPA annotated entity beans.
  • The ENGINE_INFO type was added to handle different settings in a database engine.
  • For MySQL, this is used to detect the value of lower_case_table_names.
  • Comparing table names and column names in MySQL is now case-insensitive.
  • Columns of blob, clob, text, and image type are handled.
  • Command line parsing was refactored.

What is new in version 2.1.0:

  • The user manual is refined.
  • A bug in the installation process has been fixed.
  • The scripts dzo and dzo.bat are more forgiving and try to locate the jar file.
  • Internal refactoring.
  • A fix for a bug in substitute: it is now possible to substitute values with special characters.
  • A bug in MySQL has been fixed: function/procedures/triggers/views now recreate correctly.
  • Checking has been added for duplicate dzo-X.jar files in the servlet.

What is new in version 1.7.1:

  • In this revision, the DTD when generating HTML was removed.
  • An error in the dzoTestApp has been resolved.

What is new in version 1.7.0:

  • Add support for PostgreSQL.
  • More documentation.
  • Create dzo.xml in servlet if it dont exists.
  • Corrected errors in html in servlet.
  • Fixed bug when serving pictures in servlet.
  • (MySql) Fixed bug when moving columns, cannot move after a deleted column.
  • Refactoring.
  • Handle identifiers which have the same name as a keyword.
  • Dont generate duplicates column when generating sql from jpa-annotated bean.
  • (MySql) User-name must have % in ticks ('%').
  • PostExecute checks that the original sql was successfull.

What is new in version 1.6.0:

  • More documentation.
  • Fixed bug in installation, error when installing samples.
  • Errors now showing up in web-application (dzo2.war)

What is new in version 1.5.1:

  • Corrected error in ant.bat script that is used i samples.
  • Corrected version number in maven samples/pom.xml file.

Requirements:

  • Java 2 Standard Edition Runtime Environment

Similar Software

RedQueryBuilder
RedQueryBuilder

28 Sep 15

MonetDB
MonetDB

11 May 15

MySAC
MySAC

11 May 15

Comments to Dzo

Comments not found
Add Comment
Turn on images!