Release Notes: This release adds a pre-packaged SchemaCrawler for SQLite. There is also an improved algorithm to find weak associations, and a new command-line switch to sort columns alphabetically.
Release Notes: grep functionality was built into the command line. This means that all of the SchemaCrawler commands, including graphing, can use filtering and grep options. The command line option help has been re-written. If no commands are specified, it defaults to standard_schema, a new command that provides the most commonly needed details of the schema. Graphviz DOT files are now produced as one of the native output formats for generating schema diagrams.
Release Notes: This version has a new feature that infers weak associations between tables, even if there is no foreign key. Ruby on Rails table schemes are supported, as well as other simple relationships. Table name prefixes are automatically detected. There is now database diagram support using Graphviz. Primary keys are indicated in a darker color than other columns. Foreign keys are indicated with arrow connectors. Weak associations between tables are shown in dashed lines. Multiple output formats are supported. Support for Jung is dropped.
Release Notes: SchemaCrawler does a better job of reporting ascending and descending index columns. This is an API change. There are better grep options, to allow searching through both tables and stored procedures. This release includes minor bugfixes for Sybase, including generating warnings when obtaining table column privileges instead of failing. There is a new Windows script file for locating Java and launching SchemaCrawler. There is a reorganization of the distribution so that only a single SchemaCrawler jar file is distributed in all distributions.
Release Notes: This release fixes an issue with MySQL schemas.
Release Notes: Bugfixes for recognizing -schemapattern on the command line, and data types with the Oracle driver.
Release Notes: SchemaCrawler for Microsoft SQL Server shows details of procedures and triggers. The basic SchemaCrawler distribution is simple to use for any database, because all you need to do is add the database driver. Bug fixes include correctly reporting an index as unique and correctly reporting primary key columns.
Release Notes: This release provides JDBC driver metadata, including driver properties. A new command line switch, -schemapattern, is available for specifying schema patterns when a connection is specified from the command line. Object attributes are added automatically from unused columns in the metadata calls.
Release Notes: New features include the ability to get result-set metadata. The schema info level is no longer an enumeration, but a class that is used to specify details on what aspects of the schema need to be retrieved. There is now an easier way to access foreign keys from the foreign key column itself, via isPartOfForeignKey(), and getReferencedColumn() on the Column class. Bug fixes were made to delivering all relevant license files, the way foreign key update and delete rules on Oracle are reported, and the "equals" comparison on all schema objects.