OSDN -- Develop and Download Open Source Software

RSS
Download List

Project Description

SchemaCrawler is a Java API which makes working with database metadata as easy as working with ordinary Java objects. It is also a database schema discovery and comprehension and schema documentation tool. You can search for database schema objects using regular expressions, output the schema and data in a readable text format, and find potential design issues with lint . The output is designed to be diff-ed against other database schemas. SchemaCrawler supports almost any database which has a JDBC driver, but for convenience is bundled with drivers for some commonly-used RDBMS systems. SchemaCrawler works with any operating system which supports Java.

System Requirements

System requirement is not defined
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.

2009-11-26 18:14
7.5

SchemaCrawler output has sections to make it more readable. A new -schemas command line switch replaces -schemapattern and the schemapattern option. A live connection is provided to the JavaScript context to enable scripting of the database. The database metadata returned by SchemaCrawler has a new SchemaCrawlerInfo object that provides the version number and Java system properties. Table sort is now done using graph algorithms, and includes cycle checks. There are updates to all bundled database drivers, and a bugfix for obtaining MySQL foreign keys correctly.

2009-10-28 19:28
7.4

There is a new pre-packaged SchemaCrawler for Oracle. The index sort order of primary key columns was fixed. The Web site was updated with a new front page.

2009-09-26 07:05
7.3.1

This release adds an enhancement to the JavaSqlType class to contain the SQL type group. JavaSqlTypesUtility can look up the JavaSqlType by data type. Deprecated methods for grouping SQL data types (such as isReal()) are removed from the ColumnDataType class, as well as the getTypeClass() method.

2009-09-20 03:46
7.3

This release adds support for mapping of SQL data types to Java classes. This includes the new JavaSqlType class and the JavaSqlTypesUtility. A new method, getTypeClass(), is available on ColumnDataType to obtain the mapped Java class. A new package, SchemaCrawler for Apache Derby, is customized for Apache Derby users.
Tags: Apache Derby

2009-08-27 18:51
7.2

This release adds a natural sort order for tables, based on the foreign keys, and a corresponding command-line switch, -sorttables. There are new API methods for getting child and parent tables, and better modeling of privileges and grants. Bugfixes include obtaining indexes and foreign keys with the Oracle driver, handling null schemas for databases that do not support schemas, and allowing data dumps when tables contain binary objects, by fixing the SELECT sort order.

Project Resources

Project Page Home Page