Using SchemaCrawler for creating of database schema diagrams

Installation

1. Install (unzip) the SchemaCrawler from https://github.com/schemacrawler/SchemaCrawler
2. Install Graphviz from https://www.graphviz.org/
3. Install the latest java version
4. In the SchemaCrawler installation folder:

• open the file config/schemacrawler.config.properties
• navigate to the setting schemacrawler.graph.show.foreignkey.filtered_tables
• uncomment the line and set the setting to false (s. https://github.com/schemacrawler/SchemaCrawler/discussions/818 for details)

Usage

S. PKSim-DataBase/images/CreateDBDocuPics.bat in this repository for examples of how to create full/partial database schema.

Remarks:

• It seems that SchemaCrawler modifies the database when creating schema diagrams. So it is advisable to either create a copy of the database before calling the SchemaCrawler. Or make sure that the database does not contain uncommitted changes and revert the changes after the execution of SchemaCrawler.