Schema Crawler 3.7 review

Schema Crawler project is a platform (database and OS) independent command-line tool to output your database schema and data in a rea

License: GPL (GNU General Public License) File size: 0K Developer: Sualeh Fatehi

0

Schema Crawler project is a platform (database and OS) 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. Schema Crawler is also an API that improves on standard JDBC metadata.

Build

Ant Build

The ant build is a quick build that builds the Schema Crawler jar without compiling and running unit tests. Download ant, and run it from the Schema Crawler directory. The jar file will be created in the _distrib directory. The main targets are all.build and all.clean.

Maven Build

The maven build is a more comprehensive build that runs unit tests, and also creates the project web-site. Download maven, and run it from the Schema Crawler directory. The jar file will be created in the _distrib directory. The main goals are all.build and all.clean.

Eclipse

Schema Crawler consists of two Eclipse projects, dbconnector and schemacrawler. Since schemacrawler depends on dbconnector, you will need to import both projects into Eclipse.

What's New in This Release:
Database properties are now retrieved, along with column data types, both system data types, and UDTs.
A new command, maximum_schema, gives all possible details of the schema, including database system properties.
Bugs with the merge rows option and with appending output for multiple runs of SchemaCrawler are fixed.
An SQL exception with the Oracle Database 10g Express Edition driver on outputting views is fixed.