SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. The bundled distributions of SchemaCrawler are ready to use for a given RDBMS system. Most come with open-source JDBC drivers bundled in, so not further downloads are required. The bundled distributions of SchemaCrawler are:
Ensure that you have Java 7 or better installed, and download and unzip the bundled distribution,
and you are
ready to use SchemaCrawler. No additional downloads are required. A typical command line for SchemaCrawler for
Server looks like:
-host=localhost -port=1433 -database=schemacrawler -schemas=schemacrawler.dbo -user=schemacrawler -password=schemacrawler
The host defaults to localhost, and port defaults to the standard port for the database system that you are using, so the -host and -port command-line switches are optional. You should always use the -schemas command-line switch for databases that support it. The value for the -schemas switch is a regular expression that determines which schemas SchemaCrawler will work with. The "schema" is database-dependent - for example, on Microsoft SQL Server, typically schemas look like "database_name.user", but for Oracle, typically, schemas look like "USER".
SchemaCrawler is free, and licensed under the GNU Lesser General Public License (LGPL) for distributions that do not include a JDBC driver.
SchemaCrawler distributions that are bundled with the JDBC driver are also free, and are distributed under the GNU General Public License (GPL) license. The JDBC drivers are packaged with these SchemaCrawler distributions in their binary form, and retain their original license.
Donations are welcome.
SchemaCrawler Website by Sualeh Fatehi is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License .
Based on a work at schemacrawler.sourceforge.net .