SchemaCrawler
SchemaCrawler is a platform (OS and database) independent command line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema. SchemaCrawler is also an API that improves on standard JDBC metadata.
| Tags | Database API Software Development Quality Assurance |
|---|---|
| Licenses | LGPL |
| Operating Systems | OS Independent |
| Implementation | Java |
Recent releases
- 11 May 2009 12:43
Changes: 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.
- 07 May 2009 07:17
Changes: 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.
- 09 Apr 2009 10:19
Changes: 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.
- 29 Mar 2009 21:01
Changes: 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.
- 29 Nov 2008 07:02
Changes: This release fixes an issue with MySQL schemas.
