SchemaSpy 4.0.0 released

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either via entity-relationship diagrams or through HTML tables. It works with just about any RDBMS given an appropriate JDBC driver. SchemaSpy also identifies several common schema anomalies.

SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, Firebird, PostgreSQL, HSQLDB, Informix, Sybase, MaxDB, Firebird and Derby (JavaDB).

You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/

Highlights of Release 4.0.0:

- Foreign Key relationships can now be defined when a foreign key doesn't exist in the database. That and many additional metadata settings can now be specified via XML.

- Compact view of relationships page now hides non-PK / non-indexed columns to reduce clutter and clarify the relationships.

- jQuery is now used for DOM manipulation.

- Added support for Derby (JavaDB) databases, both embedded and network.

- Added support for SQL Server with jTDS driver.

- Added support for SQL Server 2005.

- Added support for MaxDB.

- New -schemas option (similar to -all) for evaluating multiples with databases like MySQL where a database isn't composed of multiple schemas.

- Significantly improved performance of generation of entity-relationship diagrams.

- Better Unicode support resolve table name to URL mapping issues that show up with Japanese table names.

- Now allows for customizable 'get row count' SQL as a way to improve performance.

- New -font and -fontsize options.

- Many additional bugs were fixed.