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

Graph connection not displayed if there is no referential foreign key constraint

I have tables in database postgres in which some tables does not have explicit foreign key referential contraints. When I run schema crawler it does not generate graph connection for parent or child connection tables. Is there any suport for…
satish john
  • 226
  • 1
  • 6
  • 14
0
votes
1 answer

How to extract basic descriptive stats on tables using schemacrawler

Is there a way to extract stat information such as Below based on type of data type like string int etc. Count Mean Min distinct values Max Media STD null values Avg Top 10 values Without using query on each table or something more efficient way…
satish john
  • 226
  • 1
  • 6
  • 14
0
votes
1 answer

Not able to use linterconfigs command

I want to use Schemacrawler lint in my project and wants to use custom lints only. Based on documentation , it says we can use command -linterconfigs=[path to linter XML configuration file] But when I tried creating XML configuration file and use…
0
votes
1 answer

No relationship between tables shown in schema diagram when using add_reference in Rails

I am working on a Rails application where I need to add some of the Foreign keys for existing columns from Rails migrations and few people working on same as well. I am adding this way: class AddUserRefToEvents < ActiveRecord::Migration[5.2] def…
0
votes
0 answers

How to generate graph from SQL Server database?

I'm trying to generate a graph of SQL Server tables. For some reason -command=graph and outputformat=pdf are not working. I was able to generate the HTML report when I run with -command=schema but command=graph is not even working.…
DBA
  • 11
  • 2
0
votes
1 answer

Pass command-line argument to schemacrawler programmatically

I'm using SchemaCrawler v14.21.02 programmatically in my Java project to generate schema diagrams. I would like to generate a diagram with a reduced set of columns, as done by adding the option -infolevel=standard -command=brief when running…
hjh
  • 1
  • 1
0
votes
1 answer

SchemaCrawler error when adding MariaDB artifact

When I add this to the pom.xml: us.fatehi schemacrawler-mariadb
Adder
  • 5,708
  • 1
  • 28
  • 56
0
votes
1 answer

Multiple filterings with Schemacrawler?

I'd like to filter out multiple patterns, because our schema has superfluous (for the purposes of the intended diagram) table names such as foo_AUDIT, bar_enum_baz, and SYSTEM. So I'd like to hide all tables containing AUDIT, enum, or SYSTEM. But is…
Jon Lauridsen
  • 2,521
  • 5
  • 31
  • 38
0
votes
1 answer

Does schemacrawler supports Hive?

I am looking for data visualization tool which supports Hive database. Does schemacrawler supports Hive? If not, any roadmap to support it in future. Any other tools which support Hive to view its metadata? Let me know.
0
votes
1 answer

Can SchemaCrawler transfer data to another database?

If we have oldDatabase and newDatabase. In newDatabase table cats was renamed to kittens and was added extra table puppies. Would SchemaCrawler be able to transfer data from oldDatabase to newDatabase, recognising new table names and if there are…
Alyona
  • 1,682
  • 2
  • 21
  • 44
0
votes
1 answer

Which JAR files are required for SchemaCrawler?

I'm using Eclipse, SQLite database and Hibernate. I want to use SchemaCrawler in my project, already have sqlite-jdbc library. My aim is to compare using SchemaCrawler structure of two databases. But I can't even connect to my first database. I am…
Alyona
  • 1,682
  • 2
  • 21
  • 44
0
votes
1 answer

How to compare two database structures?

I'm using SQLite/Hibernate. Idea is to check each time app starts whether database structure is up to date. I have my existing database in "DB" folder and each time app start I'm creating up to date database in "DB/structure" folder. I want to…
Alyona
  • 1,682
  • 2
  • 21
  • 44
0
votes
1 answer

Do not show relations to invisible tables in SchemaCrawler diagram

I use schemacrawler-14.16.03 on Windows 7. My command is: schemacrawler.cmd -server=postgresql -host=hostname -port=5432 -database=db -schemas=public -user=user -password=***-sslmode=require -loglevel=INFO -outputformat png -infolevel=standard…
stray
  • 5
  • 2
0
votes
1 answer

schemacrawler sqlite3 no suitable driver

Using SchemaCrawler for the first time, no previous experience with it. Ubuntu 16.04.2, installed SchemaCrawler using adriens deb package. Docs indicate sqlite is supported out of the box with xerial's jdbc driver. With this command…
Dave Nicolette
  • 171
  • 1
  • 9
0
votes
1 answer

Can I get schemacrawler to ignore the schema name?

I'm attempting to make a comparison of two Oracle DBs - I'm running a report on two different schema names - in my case, a schema prefix. E.g. Using: -schemas=FOO.* then -schemas=BAR.* Is there a way of hiding this prefix from the report, so that…
Ads
  • 57
  • 1
  • 7