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
1
vote
1 answer

schemacrawler not returning all Oracle tables - what permissions are required?

Using schemacrawler and trying to connect to an Oracle database. The resulting json file is only including about 10 tables, but we are expecting a much larger number of tables in the database. This must be restricted by permissions of the user…
Scott Flory
  • 11
  • 1
1
vote
1 answer

SchemaCrawler not able to find MSSQL tables

I'm trying to export a schema from MSSQL database using SchemaCrawler & jTDS driver (version 1.3.1). The command is: ./schemacrawler.sh \ -server=sqlserver \ -password= \ -command=schema \ -outputformat=png \ …
Stano
  • 171
  • 2
  • 6
1
vote
1 answer

Error: Could not find or load main class schemacrawler.Main

I'm following the cross-platform installation instructions on osx. I downloaded the latest .zip from the releases page. And do $ cp -R _schemacrawler/ /usr/local/bin/ $ schemacrawler.sh Error: Could not find or load main class…
Harry Moreno
  • 10,231
  • 7
  • 64
  • 116
1
vote
1 answer

Schemacrawler in OSGi bundle

I'm really new to Schemacrawler and I need a little help. I want to use Schemacrawler as OSGi bundle in my project. However I'm not sure how to do it. In the Readme, it says that "The SchemaCrawler jar file is bundled as an OSGi bundle". But there…
Eli
  • 69
  • 1
  • 7
1
vote
1 answer

How to get trigger information with SchemaCrawler of SQL Server database

I'm using the command-line of SchemaCrawler in combination with a SQL Server Database (2014). I get information of the most item in de database but I don't know how to get information of triggers. I read and tried several things but I can't get the…
Jhonny
  • 11
  • 2
1
vote
1 answer

NPE when generating graph using SchemaCrawler Maven plugin

I want to generate DB schema graph using SchemaCrawler and it's Maven plugin. I don't want to use constructions like java -classpath ../_schemacrawler/lib/*:lib/* ... because it must be universal. I want to use Maven for all dependencies and users…
Radzikowski
  • 2,377
  • 4
  • 27
  • 39
1
vote
1 answer

schemacrawler returning tables from all available databases

I am using schemacrawler for getting table list from mysql database. The problem is, the result includes table from all the available databases. It is getting tables from outside the given database name(DataSource).
Khader M A
  • 5,423
  • 3
  • 19
  • 19
1
vote
1 answer

Schemacrawler doesn't output Oracle sequences

I'm running SchemaCrawler command line against Oracle and I can't get the Oracle Sequences in the output. I only get the tables that match my regex. I've confirmed that the sequences exist in the schema and that the user has access to them. What…
MarkOfHall
  • 3,334
  • 1
  • 26
  • 30
1
vote
0 answers

exception exception while using schemaCrawler

I got this exception while using schemaCrawler with Oracle Database 10g, does anyone know what did that mean? Avertissement: JDBC driver does not support retrieving functions java.lang.AbstractMethodError:…
user3271235
  • 11
  • 1
1
vote
1 answer

Adding multiple schemas to schemainclusionrule schema crawler

I have to add selected schemas to be crawled using schemacrawler. How can we add multiple schemas into inclusion rule of schemacrawler? like : final SchemaCrawlerOptions options = new SchemaCrawlerOptions(); options.setSchemaInclusionRule(new…
sathishs
  • 109
  • 1
  • 11
0
votes
1 answer

Sharepoint Columns had no property created for search

I have created 15 columns in my Sharepoint Site Document List, and I need to be able to filter or search this list by any of them. But when I created them, only 10 of them where crawled and a ows property create for them. The other 5 where not. Does…
rread
  • 143
  • 1
  • 13
0
votes
0 answers

SchemaCrawler - Multiple Schema Definition Extraction

--schemas= is a regular expression to match fully qualified schema names, in the form "CATALOGNAME. SCHEMANAME" - for example, --schemas=.*\.C.*|.*\. …
Narayan Aher
  • 1
0
votes
1 answer

I am using Schemacrawler Utility to compare two databases in java so I am trying to get triggers information but it is giving empty array

This is the code I am using to get triggers information using schemacrawler utility class in java. I am extracting metadata so i need whole metadata information. `public class Metadata { /** * Extracts metadata from a database connection using…
Mansi Jain
  • 1
0
votes
0 answers

SchemaCrawler db2 plugin not found

I have the plugin following in my gradle.build: implementation 'us.fatehi:schemacrawler-db2:16.19.10' But getting following exception message: INFO: Not using any SchemaCrawler database plugin InternalRuntimeException: Add the SchemaCrawler…
JMX
  • 21
  • 1
  • 6
0
votes
1 answer

schemacrawler and sqlite3 - No database connection URL template provided

Refer to the schemacrawler example and this similar topic, I also tried to get a diagram from a sqlite3 file with below commands, but observe No database connection URL template provided errors. Could anyone help to provide some advises? Thanks! $…
Phenix6126
  • 3
  • 2
1
2
3 4 5 6 7 8