Stack Overflow
Stack Overflow

Questions tagged [schemacrawler]

SchemaCrawler is a free database schema discovery and comprehension tool.

SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format. The output serves for database documentation, and is designed to be diff-ed against other database schemas. SchemaCrawler also generates schema diagrams. You can execute scripts in any standard scripting language against your database. You can find potential schema design issues with lint.

SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java 8 or better.

108 questions
0
votes
1 answer

Want to generate ER diagram with weak associations. where to define attributes file

I am running SchemaCrawler through docker container. I have tables in database ORACLE in which all tables does not have explicit foreign key referential constraints. I want to generate ER diagram with weak associations. But don't know where to…
Aaru Mote
  • 1
0
votes
1 answer

How to pass xml linter config in code using Schemacrawler API

Command-line schemacrawler has --linter-configs option, where we can pass xml config. Is it possible to pass this linter-config.xml with schemacrawler API in code?
Mikhail
  • 31
  • 4
0
votes
1 answer

Remove "Generated" labels in schemacrawler

In schemacrawler, is there an option to remove the "Generated by Schemacrawler" and "Generated on ..." labels? I've checked the documentation and failed to find this option.
user2058738
  • 349
  • 1
  • 6
  • 15
0
votes
1 answer

SchemaCrawler Error opening socket to server DB2 database

I have tried to connect to a DB2 DB using the command line: schemacrawler --server=db2 --host=*myhost* --port=*myport* --database=*db2database* --user=*myuser* --password=*mypassword* --info-level=minimum --command=list --log-level=CONFIG I get the…
German Chacon
  • 1
  • 2
0
votes
1 answer

Schemacrawler partition large schema based on number of tables

I have a use case where I am using schemacrawler to crawl metadata from various databases. And use the metadata later on in my downstream system. I have lot of variable size databases to crawl. The number of tables vary from 20-2000. Now, I am using…
Himangshu Das
  • 1
0
votes
1 answer

Upgrading projects using schemacrawler

I'm currently ugrading all my projects that use Schemacrawler. The last version I used was 15.06.01 and I'm upgrading to 16.9.4. A lot of changes were done, I'm looking for the object that replace LintedCatalog.java. The aim is to get the list of…
Michèle
  • 3
  • 1
0
votes
1 answer

SchemaCrawler Java API: add new options to SchemaRetrievalOptions

I'd like to be able to get columns on which the table I'm getting metadata on has constraints. In order to do that, I'd have to look up the value of the columns field for a Constraint (or, in my case, MutableTableConstraint), and constraints are…
wouldnotliketo
  • 153
  • 1
  • 10
0
votes
1 answer

SchemaCrawler Java API retrieve check column constraints

Per this question and its comments, in order to obtain constraints (I'm particularly interested in check constraints), one must do the following: Include a .jar corresponding to their DB driver of choice, like schemacrawler-postgresql or…
wouldnotliketo
  • 153
  • 1
  • 10
0
votes
1 answer

Schemacrawler cannot output the schema from DB2 (and Oracle) server in JSON format

I am trying to use SchemaCrawler to extract schema information on db2 test database. When running the schema command with text or html format, things work as expected: ./schemacrawler.sh --server=db2 --host=127.0.0.1 --port=50000 --database=sample…
Sutandiono
  • 1,748
  • 1
  • 12
  • 21
0
votes
1 answer

SchemaCrawler user name and roles

I am using schema crawler in my project. Is there any way to get the Users and their roles ? There catalogue object doesn't contain any such information . I am using this configuration : val schemaCrawlerOptions = SchemaCrawlerOptionsBuilder …
Abhishek Sengupta
  • 2,938
  • 1
  • 28
  • 35
0
votes
1 answer

Output PostgreSQL enum types

I have some custom enum types (e.g. CREATE TYPE speedType AS ENUM ('kph', 'mph', 'mps');) in a PostgreSQL DB. Can I output that with the Schemacrawler command line tool?
ASI
  • 11
  • 2
0
votes
1 answer

Can you grep/search case-insensitive in SchemaCrawler?

Is there a flag or option that will allow SchemaCrawler to search database objects and ignore case? The following example will filter out stored procedures that start with "API" even though they are desired output: --routines=.*api_Insert.*
Jared Beach
  • 2,635
  • 34
  • 38
0
votes
1 answer

Change font style for column comments in SchemaCrawler

Is there any way to change the font style for Column comments that are rendered to schema image? Currently column comments assigned in SQLAlchemy using eg…
H3007
  • 46
  • 5
0
votes
1 answer

SchemaCrawler 16.12 version command line not creating my htmlx output

I am using the latest version of schemacrawler (16.1.2) to generate SVG diagrams embedded in HTML output. However it is not creating the diagrams but only printing the table information in text form. If I use an older version of schemacrawler, it…
Phillip Hayes Jr
  • 1
0
votes
0 answers

How Can I Get View Definitions?

I'd like to get the View definitions from a PostgreSQL schema so that I can create the same views on a target database. I get all the information from the SchemaCrawler except the table that the View is based on. Is this possible? Or instead of the…
Rebel Geek
  • 11
  • 2
1 2 3
4
5 6 7 8