Menu

SchemaSpy 5.0.0 released

SchemaSpy analyzes database metadata to reverse engineer dynamic Entity Relationship (ER) diagrams. It works with just about any JDBC-compliant database (Oracle/MySQL/DB2/SQL Server/PostgreSQL/Sybase/etc) and can identify Ruby on Rails relationships.

Highlights of Release 5.0.0:

- Added SQL to query view details for MySQL databases.

- On the tables tab you can now view tables and views separately as well as hide comments.

- The columns page has been trimmed down to help resolve loading issues on large (e.g. 20,000 table) schemas.

- Support for z/OS-based DB2 systems.

- New option to exclude specific tables based on a regular expressions.

- New -gv option to no longer require finding Graphviz on the path.

- Now shows details about foreign key constraint deletion rules: cascade on delete, null on delete and restrict delete.

- Added hooks to allow for custom formatting of view SQL.

- Now treats DB2 Materialized Query Tables (MQTs) as views.

- New -logLevel option to display verbose details of program flow.

- New option to prompt for password so it doesn't appear on the process's command line.

- New -noviews option that causes SchemaSpy exclude all views from its analysis.

- Many additional bugs were fixed.

Posted by John Currier 2010-08-16

Log in to post a comment.