SchemaSpy 2.0.0 released

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either graphically 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, PostgreSQL, HSQLDB and Sybase.

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

Highlights of Release 2.0.0:

- SchemaSpy now uses a tabbed layout that results in a significantly cleaner page.

- You now have the ability to explicitly exclude columns from the relationship analysis using a regular expression notation. This keeps those pesky tables that are related to everything from severely cluttering your view of your schema.

- Added information in the graphs about how many 'parent' and 'child' tables are related to a given table. This gives a visual clue that there are more tables beyond the outskirts of what's currently visible.

- SchemaSpy now supports HSQLDB thanks to bension providing a hsqldb.properties configuration file.

- Added support for DB2 UDB Type 4 driver.

- The graphs are now clearer due to the use of a sans serif font.

- Resolution of bug #1340880 - accent characters cause dot to fail. SchemaSpy now generates the .dot files using the UTF-8 character set, which is what the dot program expects.