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
0 answers

Schemacrawler container could not connect to host postgresql database

I tried to run the following schemacrawler container on my Ubuntu 18.04 machine: docker run \ --mount type=bind,source="$(pwd)",target=/home/schcrwlr \ --rm -it \ schemacrawler/schemacrawler:v16.19.7 \ /opt/schemacrawler/bin/schemacrawler.sh…
laos
  • 1
0
votes
1 answer

Is there any way to plugin a custom weak association detection logic into schemacrawler?

I am using schemacrawler cli to generate diagrams for my database. I do not have many FK relationships in my db and so I am relying on weak-associations. But the these weak associations are not accurate. Is there any way to plugin custom logic for…
Sai Phaninder Reddy J
  • 424
  • 5
  • 8
0
votes
1 answer

How to generate .dot file using Schemacrawler

Using schemcrawler I've generated html file public final class ExecutableExample { public static void main(final String[] args) throws Exception { // Set log level new LoggingConfig(Level.OFF); final LimitOptionsBuilder…
Programmer
  • 105
  • 2
  • 6
0
votes
1 answer

SchemaCrawler database plugin should be on the CLASSPATH

I have to get metadata of DB using schemacrawler. According to https://www.schemacrawler.com/ where I have found example…
Programmer
  • 105
  • 2
  • 6
0
votes
1 answer

How do I use schema crawler to establish a connection with the database and get the result?

I'm using this Gradle dependency in my project implementation group: 'us.fatehi', name: 'schemacrawler', version: '16.16.14' The project is in Scala language and DB2 is the database that's used. This is piece if scala code I'm using: val…
wagonr
  • 5
  • 3
0
votes
1 answer

schemacrawler java.lang.NullPointerException: Catalog could not be retrieved

I try to use schemacrawler with hsqldb 2.51 and h2 2.x with the following code: final LimitOptionsBuilder limit = LimitOptionsBuilder.builder() .includeSchemas(new IncludeAll()) .includeTables(new IncludeAll()); final LoadOptionsBuilder load…
psilocybe
  • 35
  • 6
0
votes
1 answer

Using SchemaCrawler API to get Weak/Implied Relationships

I'm using the SchemaCrawler API in a data migration tool I'm developing. This is running on MySQL 5.6.25 with v16.16.9 of the SchemaCrawler API. Unfortunately, SC isn't finding any weak relationships in the database, even though other tools are…
Gillman
  • 35
  • 1
  • 1
  • 4
0
votes
1 answer

Load SQLite extensions in SchemaCrawler

My SQLite database has a virtual table that is created by using the spelfix1.dll extention. Is there any solution to load this extention in schemacrawler? When I try to create the graphic with schemacrawler --server=sqlite…
tomko
  • 54
  • 7
0
votes
1 answer

SchemaCrawler Code to produce a simple .dot file

I would like produce a file which contains pairs of tables; a master on the left and a detail on the right or said another way parent and child. In the article: "How to Visualize Your SQLite Database with One Command" using --output-file=output.png…
Robert Garvey
  • 1
0
votes
0 answers

Question Regarding week relationships on views

Can we create week relationships on views (or) there is any solution to create informative constraints against view instead of table for ER diagram creation
Samineni Krishna
  • 1
0
votes
1 answer

Does SchemaCrawler Support Salesforce?

I'm currently using schemacrawler to extract metadata for MySQL and MSSQL types of source systems. But curious to know whether it supports Salesforce Data? From the docs I do not see the option though. Any help would be appreciated
Kulasangar
  • 9,046
  • 5
  • 51
  • 82
0
votes
0 answers

How to generate schema diagram using Java schemacrawler API

I want to generate schema diagram of a database using Java schemacrawler API .I want the output in HTML format.i am able to generate the schema diagram from command prompt.
user3279098
  • 1
0
votes
0 answers

schemacrawler oracle-plugin not returning SYNONYMS

I am using schema-crawler to crawl an oracle database (Retrieve Table/Synonym metadata including columns details and foreign keys) INFO: -- generated by: SchemaCrawler 16.15.1 -- database: Oracle Oracle Database 12c Standard Edition Release…
pungaa
  • 1
  • 1
0
votes
1 answer

how to fetch ER diagram for DB2 datawarehouse using schemacrawler

i m using db2 data warehouse. I am using schemacrawler to fetch the ER diagram. In my data warehouse PK and FK are not mentioned. So I want to ask that can we add PK and FK through Schemacrawler to fetch the ER diagram. I have read weak-associations…
Samineni Krishna
  • 1
0
votes
1 answer

Does SchemaCrawler have the ability to extend to support multiple versions of the same Data Source?

I am new to SchemaCrawler and impressed with the SchemaCrawler. In my project, I need to retrieve the schema for a different version of the same data source. Example: How to connect MS SQL server version 2005 and 2019 both at the same time?
Amit Bhoyar
  • 13
  • 7
1 2
3
4 5 6 7 8