Schema Crawler is a platform (OS and database) independent command-line tool to output your database schema.
Version: 3.7Schema Crawler project is a platform (database and OS) independent command-line tool to output your database schema and data in a readable form.
Operating System: Linux
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.
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.
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.
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.