Older News Items

Project News for SchemaSpy

  • 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.

    2010-08-16 16:26:29 PDT by johncurrier

  • SchemaSpy 4.1.1 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/

    Release 4.1.1 is a bug patch release resolving issues with the extends directive as well as null IDs on DB2 views.

    2008-10-20 10:04:00 PDT by johncurrier

  • SchemaSpy 4.1.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.1.0:

    - Can now fully evaluate Ruby on Rails databases that associate foreign keys to primary tables/keys with a translation of singular to plural form.

    - Resolved a bug where SchemaSpy was using incorrect entity relationship diagram notation.

    - Added a new import directive to database configuration files to be able to reuse complex SQL (or other settings) from configurations not in the normal inheritance tree.

    - Added support for MS SQL Server 2005 with jTDS driver, including column comment retrieval for all of the MS SQL databases.

    - Can now specify database connection properties on the command line.

    - New sso option to support single sign-on databases.

    2008-10-17 15:35:32 PDT by johncurrier

  • 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.

    2008-09-24 14:41:12 PDT by johncurrier

  • SchemaSpy 3.1.1 released

    SchemaSpy analyzes database 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, Firebird, PostgreSQL, HSQLDB, Informix and Sybase.

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


    Highlights of Release 3.1.1:

    This is a bug-fix release intended to address the Graphviz 2.9+ changes that broke SchemaSpy.

    - Resolved bug 1602135 - Exception using dot version 2.9.

    - Resolved bug 1571711 - Fail to use precompiled version of dot on MacOS-X.

    - Resolved bug 1597609 - Quoting and Sybase ASE.

    2006-12-18 08:11:44 PST by johncurrier