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.
Log in to post a comment.