SchemaCrawler
Special Features
- SchemaCrawler Grep
- Database Diagramming
- Database Scripting
- SchemaCrawler Lint
- Using INFORMATION_SCHEMA Views
Project Pages
- Donations
- Download
- Change History
- Javadocs
- Source Code
- Project Page on SourceForge
SchemaCrawler
Release History
| Version | Date | Description |
|---|---|---|
| 10.2 | 2013-05-21 | |
| 10.1 | 2013-04-21 | |
| 9.6 | 2013-03-08 | |
| 9.5 | 2013-02-24 | |
| 9.4 | 2013-02-02 | |
| 9.3.2 | 2012-11-17 | |
| 9.3.1 | 2012-11-3 | |
| 9.3 | 2012-10-31 | |
| 9.2 | 2012-10-21 | |
| 9.1 | 2012-09-30 | |
| 9.0 | 2012-09-08 | |
| 8.17 | 2012-07-12 | |
| 8.16 | 2012-06-20 | |
| 8.15 | 2012-05-05 | |
| 8.14 | 2012-04-08 | |
| 8.12 | 2012-02-25 | |
| 8.11 | 2012-02-18 | |
| 8.10 | 2011-12-08 | |
| 8.9 | 2011-12-08 | |
| 8.8 | 2011-11-05 | |
| 8.7 | 2011-09-05 | |
| 8.6 | 2011-05-08 | |
| 8.5.1 | 2011-01-28 | |
| 8.5 | 2011-01-28 | |
| 8.4 | 2010-12-23 | |
| 8.3.3 | 2010-08-01 | |
| 8.3.2 | 2010-08-01 | |
| 8.3.1 | 2010-07-18 | |
| 8.3 | 2010-07-15 | |
| 8.2 | 2010-05-25 | |
| 8.1 | 2010-02-28 | |
| 8.0 | 2010-02-03 | |
| 7.6 | 2009-12-03 | |
| 7.5.1 | 2009-11-28 | |
| 7.5 | 2009-11-25 | |
| 7.4 | 2009-09-24 | |
| 7.3.1 | 2009-09-24 | |
| 7.3 | 2009-09-19 | |
| 7.2 | 2009-08-21 | |
| 7.1 | 2009-08-12 | |
| 7.0 | 2009-07-10 | |
| 6.4 | 2009-05-10 | |
| 6.3 | 2009-05-08 | |
| 6.2 | 2009-04-08 | |
| 6.1 | 2009-03-29 | |
| 6.0.2 | 2008-11-30 | |
| 6.0.1 | 2008-10-30 | |
| 6.0 | 2008-10-16 | |
| 5.5 | 2008-02-28 | |
| 5.4 | 2007-12-15 | |
| 5.3 | 2007-11-15 | |
| 5.2 | 2007-10-30 | |
| 5.1 | 2007-08-05 | |
| 5.0 | 2007-06-25 | |
| 4.2 | 2007-01-07 | |
| 4.1 | 2006-12-07 | |
| 4.0 | 2006-12-03 | |
| 3.8 | 2006-09-26 | |
| 3.7 | 2006-06-12 | |
| 3.6 | 2006-03-28 | |
| 3.5 | 2006-03-06 | |
| 3.4 | 2006-01-16 | |
| 3.3 | 2005-11-03 |
Release 10.2 - 2013-05-21
| Type | Changes | By |
|---|---|---|
 | New option to set output encoding format. The option is "schemacrawler.encoding.output" in the SchemaCrawler properties file. Default input and output encoding has been changed to UTF-8. | Sualeh Fatehi |
| Support for showing trigger information in Sqlite. | Sualeh Fatehi |
Release 10.1 - 2013-04-21
| Type | Changes | By |
|---|---|---|
| SchemaCrawler support for J2SE 7 only, since previous Java versions are deprecated. Converted the codebase over to use J2SE 7 constructs. | Sualeh Fatehi |
| New command-line option, -only-matching, to show only matching tables, and does not show foreign keys that reference other non-matching tables. Modeled after the analogous grep option. | Sualeh Fatehi |
| New option to set input encoding format for script files and templates. The option is "schemacrawler.encoding.input" in the SchemaCrawler properties file. | Sualeh Fatehi |
 | Renamed command-line option -table_types to -tabletypes. | Sualeh Fatehi |
Release 9.6 - 2013-03-08
| Type | Changes | By |
|---|---|---|
| Fixed diagram generation on Linux when no GraphViz options are supplied. | Sualeh Fatehi |
| Added trigger names to JSON output by default. Added new configuration variable, schemacrawler.format.hide_trigger_names to suppress trigger names in all output formats. | Sualeh Fatehi |
| Added new -portablenames command-line option, to allow for easy comparison between databases, by hiding foreign key names, constraint names, trigger names, index and primary key names, and not showing the fully-qualified table name. | Sualeh Fatehi |
Release 9.5 - 2013-02-24
| Type | Changes | By |
|---|---|---|
| Updated HTML generation to have captions consistently for all tables. Numeric data is right-aligned in HTML, and correctly reported in JSON as well. These changes affect other output formats as well. | Sualeh Fatehi |
| Updated Oracle database connection URL to the new syntax. | Sualeh Fatehi |
Release 9.4 - 2013-02-02
| Type | Changes | By |
|---|---|---|
| Fix for honoring text formatting options in GraphViz dot output. | Sualeh Fatehi |
Release 9.3 - 2012-10-31
| Type | Changes | By |
|---|---|---|
| Weak associations are returned sorted. | Sualeh Fatehi |
| Added ability to specify additional command line options for GraphViz, using either Java system properties, or environmental variables. | Sualeh Fatehi |
Release 9.2 - 2012-10-21
| Type | Changes | By |
|---|---|---|
| Fixed Windows script, sc.cmd. | Sualeh Fatehi |
| Better support for sqlite, including the latest database driver, reporting of foreign keys, and view definitions. | Sualeh Fatehi |
| Updated the jTDS JDBC driver to 1.2.6, for Microsoft SQL Server. | Sualeh Fatehi |
| Deprecated the getType() method on database objects. | Sualeh Fatehi |
Release 9.1 - 2012-09-30
| Type | Changes | By |
|---|---|---|
| Added examples for Groovy, Ruby and Python scripting. | Sualeh Fatehi |
| SchemaCrawler is now bundled as an OSGi jar. | Sualeh Fatehi |
Release 9.0 - 2012-09-08
| Type | Changes | By |
|---|---|---|
| The API has changed from 8.x versions. All API calls return collections instead of arrays. Schemas are not containers, but tags for database objects. Tables and routines (stored procedures and functions) are available directly on the database, and there are new finders to search by schema. | Sualeh Fatehi |
| Support for database functions has been added. All references to stored procedures in the code and documentation now refer to routines. Stored procedures and functions are treated in the same way, as routines. | Sualeh Fatehi |
| SchemaCrawler now allows queries to be specified on the command-line. If a command is not recognized, or is not a named query, it is executed as if it is a query. | Sualeh Fatehi |
| The output format includes trgger definitions as part of the schema, instead of as the detailed schema output. | Sualeh Fatehi |
| Database connections have to be specified on the command-line, by providing the driver class name and URL. Database connections can no longer be defined in properties files. | Sualeh Fatehi |
| There are new command-line options. -V, --version will print the SchemaCrawler version and exit. There are shorter and more standard (Unix-like) synonyms -u (for -user), -c (for -command), and -o (for -output). The -procedures switch has been renamed -routines. | Sualeh Fatehi |
Release 8.17 - 2012-07-12
| Type | Changes | By |
|---|---|---|
| The HTML output format outputs valid HTML5 and CSS3, as valid XML. | Sualeh Fatehi |
| JSON output supports all of the formatting options that the other text formats support. | Sualeh Fatehi |
| A new method, getShortName(), get the unqualified name for columns and other dependent objects. | Sualeh Fatehi |
| A new text format option, "schemacrawler.format.show_unqualified_names", shows the unqualified name in text output, for easier comparisons across different catalogs and schemas. | Sualeh Fatehi |
Release 8.16 - 2012-06-20
| Type | Changes | By |
|---|---|---|
| Added support for synonyms. Synonyms are shown in SchemaCrawler output for IBM DB2, Oracle, and Microsoft SQL Server, as well as available for extension in other databases. | Sualeh Fatehi |
Release 8.14 - 2012-04-08
| Type | Changes | By |
|---|---|---|
| Added new command-line switch to show parent and child tables, in addition to those selected by grep. | Sualeh Fatehi |
Release 8.11 - 2012-02-18
| Type | Changes | By |
|---|---|---|
| Added ability to configure SchemaCrawler linters. | Sualeh Fatehi |
| Added a new lint for useless surrogate keys. | Sualeh Fatehi |
| Added ability to tag tables and columns with additional metadata attributes from SQL queries. | Sualeh Fatehi |
Release 8.10 - 2011-12-08
| Type | Changes | By |
|---|---|---|
| Added SchemaCrawler Lint as a separate report, with ability to add custom linters. | Sualeh Fatehi |
| Added additional SchemaCrawler linters. | Sualeh Fatehi |
| Added ability to extend SchemaCrawler with custom command. | Sualeh Fatehi |
| Fixed issue with constraints with the same name in different schemas. | Sualeh Fatehi |
Release 8.9 - 2011-12-08
| Type | Changes | By |
|---|---|---|
| Added SchemaCrawler Lint as a separate report, with ability to add custom linters. | Sualeh Fatehi |
| Added additional SchemaCrawler linters. | Sualeh Fatehi |
| Added ability to extend SchemaCrawler with custom command. | Sualeh Fatehi |
| Fixed issue with constraints with the same name in different schemas. | Sualeh Fatehi |
Release 8.8 - 2011-11-05
| Type | Changes | By |
|---|---|---|
| Added JSON and TSV output formats. | Sualeh Fatehi |
| Moved SchemaCrawler Maven Plugin into a new SourceForge project. | Sualeh Fatehi |
Release 8.7 - 2011-09-05
| Type | Changes | By |
|---|---|---|
| New INFORMATION_SCHEMA views to provide Oracle metadata details. | Sualeh Fatehi |
 | Update database driver versions. | Sualeh Fatehi |
| Fixed bug #3392557 - NullPointer exception thrown when columns excluded in Oracle. | Sualeh Fatehi |
| Fixed bug #3392976 - Exception retrieving tables: Could not retrieve indices for Oracle schemas with $ in the name. | Sualeh Fatehi |
| Fixed bug #3401752 - Attempt to locate database 'dbo' by name failed. | Sualeh Fatehi |
Release 8.6 - 2011-05-08
| Type | Changes | By |
|---|---|---|
| New feature to chain, or run multiple SchemaCrawler commands using JavaScript. | Sualeh Fatehi |
Release 8.5.1 - 2011-01-28
| Type | Changes | By |
|---|---|---|
| Re-organized command line code, including grep command line. | Sualeh Fatehi |
Release 8.5 - 2011-01-28
| Type | Changes | By |
|---|---|---|
| Changed copyright to 2011. | Sualeh Fatehi |
| Fixed grep. | Sualeh Fatehi |
| Removed option to provide index info SQL. | Sualeh Fatehi |
| Better unit test coverage. Restructuring of Eclipse projects. | Sualeh Fatehi |
Release 8.4 - 2010-12-23
| Type | Changes | By |
|---|---|---|
| Simplified commands - list_objects is now simply list. Removed the -show_stored_procedures command line option - simply use -proedures= | Sualeh Fatehi |
| Fixed issue with obtaining PostgreSQL tables. | Sualeh Fatehi |
| Fixed issue with obtaining Derby foreign keys. | Sualeh Fatehi |
| Made -infolevel a required command line argument. | Sualeh Fatehi |
| Use Maven 3.0 in the build. | Sualeh Fatehi |
Release 8.3.3 - 2010-08-01
| Type | Changes | By |
|---|---|---|
| Added color to headings in HTML output. | Sualeh Fatehi |
| Fixed bug when remarks header was not shown if the table did not have remarks, but columns did. | Sualeh Fatehi |
| DB2 INFORMATION_SCHCEMA SQL fixed. | Sualeh Fatehi |
| Foreign keys show full column names in graphs, even when the table is excluded. | Sualeh Fatehi |
Release 8.3.2 - 2010-08-01
| Type | Changes | By |
|---|---|---|
| Column remarks are printed along with table remarks. | Sualeh Fatehi |
| Foreign keys show full column names in graphs, even when the table is excluded. | Sualeh Fatehi |
Release 8.3.1 - 2010-07-18
| Type | Changes | By |
|---|---|---|
| Added new command line option, -urlx, to pass JDBC URL properties to bundled distributions. | Sualeh Fatehi |
| Added details on the "main" command line in the how-to section of the website. | Sualeh Fatehi |
Release 8.3 - 2010-07-15
| Type | Changes | By |
|---|---|---|
| Added new bundled distribution for IBM DB2. | Sualeh Fatehi |
| Added new bundled distribution for HyperSQL 2.0.0. | Sualeh Fatehi |
| Added support for spaces in schema and catalog names. | Sualeh Fatehi |
| Changed the test database to HyperSQL 2.0.0. Changed the test data, and added more robust unit tests. | Sualeh Fatehi |
Release 8.2 - 2010-05-25
| Type | Changes | By |
|---|---|---|
| Added support for spaces or reserved words in table, procedure, and column names. | Sualeh Fatehi |
| Added new database lint to find column and table names with spaces or reserved words in them. | Sualeh Fatehi |
| Added SchemaCrawler to the Sonatype Maven public repository. Added new Maven projects examples. | Sualeh Fatehi |
| Table and procedure remarks are output with verbose output. | Sualeh Fatehi |
| The Maven plug-in generates a database report that uses the same stylesheet as the rest of the Maven generated website. | Sualeh Fatehi |
| Generated database diagrams are less "colorful". | Sualeh Fatehi |
Release 8.1 - 2010-02-28
| Type | Changes | By |
|---|---|---|
| Added SchemaCrawler lint, to highlight potential normalization issues, such as incrementing column names, and other issues. A new -infolevel value, lint, was added. | Sualeh Fatehi |
| Weak associations are now available only with SchemaCrawler lint. | Sualeh Fatehi |
Release 8.0 - 2010-02-03
| Type | Changes | By |
|---|---|---|
| Added the -infolevel command-line switch to control the amount of database metadata retrieved by SchemaCrawler. | Sualeh Fatehi |
| Create a command registry, which allows pluggable commands. Any command can be run from the main class. | Sualeh Fatehi |
| Dropped the -catalogs command-line switch filtering catalogs. Dropped the concept of a catalog from the API. Databases now directly contain schemas. | Sualeh Fatehi |
Release 7.6 - 2009-12-03
| Type | Changes | By |
|---|---|---|
| Fixed specification of Oracle SID using the -database command line switch, as well as spcification of port number. | Sualeh Fatehi |
| Fixed shell script classpath. | Sualeh Fatehi |
Release 7.5.1 - 2009-11-28
| Type | Changes | By |
|---|---|---|
| Added methods to get imported and exported foreign keys and weak associations. | Sualeh Fatehi |
Release 7.5 - 2009-11-25
| Type | Changes | By |
|---|---|---|
| Added a SchemaCrawlerInfo object to the database metadata, to provide the SchemaCrawler version number, and Java system properties. | Sualeh Fatehi |
| Updates to all bundled database drivers. | Sualeh Fatehi |
| Bug-fix for obtaining MySQL foreign keys. | Sualeh Fatehi |
| Added ability to script the database, using JavaScript. A live connection is provided to the JavaScript context for this purpose. | Sualeh Fatehi |
| Removed command line switch, -schemapattern, and the schemapattern option. Use the -schemas command line switch instead. | Sualeh Fatehi |
| Added sections to SchemaCrawler output, to make it more readable. | Sualeh Fatehi |
| Tables sort is done using graph algorithms, and includes cycle checks. | Sualeh Fatehi |
Release 7.4 - 2009-09-24
| Type | Changes | By |
|---|---|---|
| Added new pre-packaged SchemaCrawler for Oracle. | Sualeh Fatehi |
| Fixed issue with index sort order of primary key columns. | Sualeh Fatehi |
| Updated website with new front page. | Sualeh Fatehi |
Release 7.3.1 - 2009-09-24
| Type | Changes | By |
|---|---|---|
| Enhancement to the JavaSqlType class, to contain the SQL type group. New lookup by data-type name added to JavaSqlTypesUtility. | Sualeh Fatehi |
| Removed method, getTypeClass(), from ColumnDataType. | Sualeh Fatehi |
| Removed deprecated methods for grouping SQL data types (such as isReal()) from the ColumnDataType class. | Sualeh Fatehi |
Release 7.3 - 2009-09-19
| Type | Changes | By |
|---|---|---|
| Added support for mapping of SQL data type to Java classes. This includes the new JavaSqlType class, and the JavaSqlTypesUtility. A new method, getTypeClass(), has been added to ColumnDataType. | Sualeh Fatehi |
| Added SchemaCrawler for Apache Derby, that is packaged for Apache Derby. | Sualeh Fatehi |
Release 7.2 - 2009-08-21
| Type | Changes | By |
|---|---|---|
| Better modeling of privileges and grants. | Sualeh Fatehi |
| Bug fix for obtaining indexes and foreign keys with the Oracle driver. | Sualeh Fatehi |
| Added natural sort order for tables, based on the foreign keys, and corresponding new configuration option, and command-line switch, -sorttables. Also added new API methods to get child and parent tables, based on the foreign keys. | Sualeh Fatehi |
| Handle null schemas for databases that do not support schemas, such as MySQL. | Sualeh Fatehi |
| Allow data dumps when tables contain binary objects, by fixing the SELECT sort order. | Sualeh Fatehi |
Release 7.1 - 2009-08-12
| Type | Changes | By |
|---|---|---|
| Better log messages, including for database connections, and inclusion of table and columns in the output. | Sualeh Fatehi |
| More efficient use of database connections, including a change to the Executable.execute method to take a database connection, rather than a data-source. | Sualeh Fatehi |
| Ensure that the pooled connection is closed, rather than the original database connection. This allows SchemaCrawler to play well with pooled connections. | Sualeh Fatehi |
Release 7.0 - 2009-07-10
| Type | Changes | By |
|---|---|---|
| Major restructuring of the API, with the introduction of a Database object that contains all of the database metadata, and containing catalog and schema objects. | Sualeh Fatehi |
| To allow for more control on table selection, the -tables command line parameter matches to the fully qualified table name, CATALOG.SCHEMA.TABLENAME. Similarly for the -routines command line parameter. | Sualeh Fatehi |
Release 6.4 - 2009-05-10
| Type | Changes | By |
|---|---|---|
| New pre-packaged distribution, SchemaCrawler for SQLite. | Sualeh Fatehi |
| Enhanced algorithm for finding weak associations. | Sualeh Fatehi |
Release 6.3 - 2009-05-08
| Type | Changes | By |
|---|---|---|
| If no commands are specified, defaults to standard_schema, which provides the most commonly needed details of the schema. | Sualeh Fatehi |
| SchemaCrawler Grep functionality is built into the SchemaCrawler options, and the SchemaCrawler command-line. This means that all of the SchemaCrawler commands, including graphing, will use filtering and grep options. | Sualeh Fatehi |
| SchemaCrawler command line option help has been re-written. New command-line options are available. | Sualeh Fatehi |
| SchemaCrawler can produce Graphviz DOT files to generate schema diagrams. | Sualeh Fatehi |
Release 6.2 - 2009-04-08
| Type | Changes | By |
|---|---|---|
| A new feature to infer 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. | Sualeh Fatehi |
| 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. | Sualeh Fatehi |
Release 6.1 - 2009-03-29
| Type | Changes | By |
|---|---|---|
| Better reporting of ascending and descending index columns. This is an API change. | Sualeh Fatehi |
| Better grep options, to allow searching through both tables and stored procedures. | Sualeh Fatehi |
| Grep options default to excluding stored procedures. | Sualeh Fatehi |
| Minor bug fixes for Sybase, including generating warnings when obtaining table column privileges, instead of failing. | Sualeh Fatehi |
| New Windows script file for locating Java, and launching SchemaCrawler. | Sualeh Fatehi |
| Reorganization of distribution, so that only a single SchemaCrawler jar file is distributed in all distributions. License distribution is also reorganized. | Sualeh Fatehi |
Release 6.0.2 - 2008-11-30
| Type | Changes | By |
|---|---|---|
| Minor bug fixes for MySQL, where the schema name was being reported as null, causing an exception. | Sualeh Fatehi |
Release 6.0.1 - 2008-10-30
| Type | Changes | By |
|---|---|---|
| Minor bug fixes for Oracle, where the data-type was a short instead of an integer. | Sualeh Fatehi |
Release 6.0 - 2008-10-16
| Type | Changes | By |
|---|---|---|
| Changed the API so that there is a separation of concerns - the SchemaInfoLevel should be an option, not a CrawlHandler property. | Sualeh Fatehi |
| Changed the API so the top level object is a catalog, which contains schemas. This means that there is full support for multiple schemas. | Sualeh Fatehi |
| Added support for JavaScript scripting. | Sualeh Fatehi |
Release 5.5 - 2008-02-28
| Type | Changes | By |
|---|---|---|
| Fixed bug that always reported an index as unique. | Sualeh Fatehi |
| Fixed bug with primary key columns. | Sualeh Fatehi |
| SchemaCrawler for Microsoft SQL Server to show procedures and triggers. | Sualeh Fatehi |
| SchemaCrawler distribution for any database. | Sualeh Fatehi |
Release 5.4 - 2007-12-15
| Type | Changes | By |
|---|---|---|
| Added new command line switch, -schemapattern, for specifying schema patterns when a connection is specified from the command line. | Sualeh Fatehi |
| Added object attributes automatically, from unused columns in the metadata calls. Nothing goes to waste. | Sualeh Fatehi |
| Added JDBC driver metadata, including driver properties, and separated those from the database system metadata. | Sualeh Fatehi |
Release 5.3 - 2007-11-15
| Type | Changes | By |
|---|---|---|
| Made sure that all relevant license files are getting delivered. | Sualeh Fatehi |
| Fixed bug in accessing foreign key update and delete rules on Oracle. | Sualeh Fatehi |
| Fixed equals comparison on all schema objects, and added a unit test for equals. | Sualeh Fatehi |
| Added an easier way to access foreign keys from the foreign key column itself Use isPartOfForeignKey(), and getReferencedColumn() on the Column class. | Sualeh Fatehi |
| Externalized the wrapper for java.sql.Types into a new public class, schemacrawler.schema.SqlDataType. | Sualeh Fatehi |
| Added the ability to get result-set metadata. | Sualeh Fatehi |
| Changed schema info level from an enum into a class that can be used to specify details on what aspects of the schema need to be retrieved. | Sualeh Fatehi |
Release 5.2 - 2007-10-30
| Type | Changes | By |
|---|---|---|
| A significant re-write of the internal command processing code. | Sualeh Fatehi |
| Spring framework support for all of SchemaCrawler functionality, including integrations and grep. | Sualeh Fatehi |
| New example for grep. | Sualeh Fatehi |
| New example for using the Spring framework with SchemaCrawler. | Sualeh Fatehi |
| Pre-packaged releases do not load config file, even if available. | Sualeh Fatehi |
| Fixed Unix shell script for PostgreSQL. | Sualeh Fatehi |
Release 5.1 - 2007-08-05
| Type | Changes | By |
|---|---|---|
| Simplified examples. | Sualeh Fatehi |
| Executable for SchemaCrawler for Microsoft SQL Server and MySQL. | Sualeh Fatehi |
| Commonly available SchemaCrawler command line argument for setting the log level. | Sualeh Fatehi |
Release 5.0 - 2007-06-25
| Type | Changes | By |
|---|---|---|
| API changed to use Java 5 constructs. Tested with Java 6. API is no longer Java 1.4 compatible. | Sualeh Fatehi |
| Started SchemaCrawler Grep for MS SQL Server. | Sualeh Fatehi |
| Fixed java.lang.AbstractMethodError with Java 6. | Sualeh Fatehi |
Release 4.2 - 2007-01-07
| Type | Changes | By |
|---|---|---|
| Fixed null pointer exception with DB2. | Sualeh Fatehi |
| Fixed error message on a bad command line. Added a general -help option. | Sualeh Fatehi |
| Added new schema grep functionality, that can search for tables and columns usng regular expressions. | Sualeh Fatehi |
| Added new example for setting options programatically. | Sualeh Fatehi |
| Added documentation for provding database connection options directly on the command line. | Sualeh Fatehi |
| Updated ant task to optionally take database connection options as arguments, instead of from the configuration file. | Sualeh Fatehi |
Release 4.1 - 2006-12-07
| Type | Changes | By |
|---|---|---|
| Fixed bug [ 1610140 ] Sorting doesn't work. | Sualeh Fatehi |
| Fixed output of standard data types. Also changed the configuration option name. | Sualeh Fatehi |
| Fixed column output for tables and procedures that contain an underscore in their name. JDBC matches the underscore to a wildcard character. | Sualeh Fatehi |
Release 4.0 - 2006-12-03
| Type | Changes | By |
|---|---|---|
| Added support for SQL standard INFORMATION_SCHEMA views. If equivalent SQL for the standard INFORMATION_SCHEMA view is specified, it is used to provide additional schema information such as check constraints, triggers, and view and procedure definitions. | Sualeh Fatehi |
| Added support for get index information views. This SQL will be used in preference to the getIndexInfo JDBC method to allow for databases and drivers that do not support getIndexInfo due to permissioning issues. | Sualeh Fatehi |
| Better output format for HTML and text. | Sualeh Fatehi |
| Better handling of output file resources. | Sualeh Fatehi |
| Better handling of database connection resources. | Sualeh Fatehi |
| More information on the website, and better website usability. | Sualeh Fatehi |
Release 3.8 - 2006-09-26
| Type | Changes | By |
|---|---|---|
| Added Maven 2.0 plugin for generation of schema reports | Sualeh Fatehi |
| Added command line option to provide database connection information | Sualeh Fatehi |
| Worked around a bug in the Oracle driver as described in http://issues.apache.org/jira/browse/DDLUTILS-29?page=all | Sualeh Fatehi |
Release 3.7 - 2006-06-12
| Type | Changes | By |
|---|---|---|
| Added retrieval of database properties | Sualeh Fatehi |
| Added retrieval of column data types, both system datatypes and UDTs | Sualeh Fatehi |
| Added unit tests to ensure that the XHTML output is valid XML | Sualeh Fatehi |
| Fixed bug with merge rows option | Sualeh Fatehi |
| Fixed bug with appending output when multiple runs of SchemaCrawler append to the same output file | Sualeh Fatehi |
| Fixed SQLException with Oracle Database 10g Express Edition driver on outputting views | Sualeh Fatehi |
| Added XStream integration for XML serialization and deserialization | Sualeh Fatehi |
| Added new command, verbose_schema, that can give all possible details of the schema | Sualeh Fatehi |
| Obtain database system properties when the maximum schema command is used | Sualeh Fatehi |
| Added integrations with FreeMarker for templated output | Sualeh Fatehi |
 | Removed Betwixt integration, since the required functionality is provided by XStream | Sualeh Fatehi |
Release 3.6 - 2006-03-28
| Type | Changes | By |
|---|---|---|
| Added integrations with Velocity for templated output, and with JUNG for JPEG graph generation | Sualeh Fatehi |
| Added new examples to demonstrate Velocity templating, and JUNG graphs | Sualeh Fatehi |
| New command line option to specify the output file name | Sualeh Fatehi |
Release 3.5 - 2006-03-06
| Type | Changes | By |
|---|---|---|
| Added ability to retrieve column and table privileges | Sualeh Fatehi |
| Added Betwixt mappings for XML serialization and de-serialization | Sualeh Fatehi |
| Added Unix shell scripts for examples | Sualeh Fatehi |
| Fixed bug with the ordering of primary key and index columns | Sualeh Fatehi |
| Changed API - ColumnInfoLevel is called SchemaInfoLevel | Sualeh Fatehi |
| Moved source repository to Subversion | Sualeh Fatehi |
Release 3.4 - 2006-01-16
| Type | Changes | By |
|---|---|---|
| Correction of spelling of the "sort_alphabetically" option names | Sualeh Fatehi |
| Refactoring of inhertance hierarchy of database objects, resulting in fewer equals, hashCode and compareTo implementations | Sualeh Fatehi |
| Better HTML formatting for counts | Sualeh Fatehi |
| Dirty reads are performed for counts and other operations | Sualeh Fatehi |
| Sets the default value for table columns | Sualeh Fatehi |
| Javadoc clean-up | Sualeh Fatehi |
| Findbugs, checkstyle, and PMD code smells clean-up | Sualeh Fatehi |
Release 3.3 - 2005-11-03
| Type | Changes | By |
|---|---|---|
| The ability to include as well as exclude tables using regular expressions. | Sualeh Fatehi |
| The ability to include as well as exclude columns using regular expressions. | Sualeh Fatehi |
| A new substitution variable, ${columns}, for use in database queries that iterate over tables. | Sualeh Fatehi |
| New examples for executing database-specific and user-defined queries have been added. | Sualeh Fatehi |
| Better output formatting for HTML dumps, and counts in text format. | Sualeh Fatehi |
| New website. | Sualeh Fatehi |
| Worked around an issue with the Sybase driver, that provides primary keys in a different order than most other drivers. | Sualeh Fatehi |
| Improved logging, and made the log level in the configuration really work. | Sualeh Fatehi |