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 creates a blank diagram

Im not sure what the problem is with my command. im on windows and running the following script -server=postgresql -host=localhost -port=5433 -database=test -schemas=public -tables=Tables -user=houdidi -password=test1234! -infolevel=maximum…
Joseph
  • 351
  • 1
  • 6
  • 17
0
votes
1 answer

What are the steps for configuring schemacrawler in Eclipse IDE and how do I use this API?

Good evening I am a student in the engineering of distributed systems Master 2. I wanted to know how to use the SchemaCrawler API to implement an application that generates metadata from a database (Mysql) and use the metadata to create an entity…
imane
  • 11
  • 3
0
votes
1 answer

Can't retrieve comments for indexes when using SchemaCrawler and MySQL5.7

I can retrieve comments for tables and columns by using SchemaCrawler and MySQL5.7, but it failed for the indexes' comments. This is an example: 1) Table definition create table testtable( id bigint unsigned auto_increment, city_id…
user1040933
  • 277
  • 5
  • 14
0
votes
1 answer

Can't retrieve the comment for columns but not table when using SchemaCrawler

I am using SchemaCrawler to get the metadata for MySQL5.7 tables using the following code: final Connection connection = ...; final DatabaseSpecificOverrideOptions databaseSpecificOverrideOptions = …
user1040933
  • 277
  • 5
  • 14
0
votes
1 answer

Is SchemaCrawler broken when using its API?

I am refering the doc in http://sualeh.github.io/SchemaCrawler/how-to.html#api But I never get what I want. The tables returned is always empty. final Connection connection = ... // Get a MYSQL connection; final SchemaCrawlerOptions options = new…
user1040933
  • 277
  • 5
  • 14
0
votes
1 answer

schema crawler--Table name pattern can not be NULL or empty

I'm running the following command: schemacrawler.cmd -server=mysql -database=prepaid -infolevel=minimum -command=list -loglevel=CONFIG -url=jdbc:mysql://127.0.0.1:3306/prepaid -u=root -schemas=prepaid And I'm getting the following error: Feb 22,…
Souad Magdy Biazid
  • 1
  • 2
0
votes
1 answer

How to use SchemaCrawler's Offline Snapshots in Java code

I think the header explains it all: Is there a nice way to create and load offline snapshots of database schema using SchemaCrawler without using command line? If yes, can you provide some example code / link please? If not, some example java code…
ZidaneT
  • 3
  • 2
0
votes
1 answer

server timezone value 'X' is unrecognized or represents more than one timezone

I'm trying to use SchemaCrawler against a MySQL database (version 5.6.17). The specific SchemaCrawler command I'm running from Windows CMD is: schemacrawler.cmd -server=mysql -database=mydb -infolevel=minimum -command=list -loglevel=CONFIG…
KcFnMi
  • 5,516
  • 10
  • 62
  • 136
0
votes
1 answer

schemacrawlar can't print out table name

blow code just print out database name only,why? public static void main(final String[] args) throws Exception { // Create a database connection final DataSource dataSource = new…
Alex Luya
  • 9,412
  • 15
  • 59
  • 91
0
votes
0 answers

Schemacrawler throws error for SQL Server

When trying to draw a schema diagram, i am not able to execute the below command sc -host=hostname -database=dw -schemas=dw\..* -infolevel=standard -routines= -infolevel=maximum -tabletypes=TABLE -grepcolumns=.*\.Accountkey -only-matching…
mhn
  • 2,660
  • 5
  • 31
  • 51
0
votes
1 answer

Schema crawler reading data from table

I understood we can read data from a table using command in Schema crawler. How to do that programatically in java. I could see example to read schema , table etc. But how to get data? Thanks in advance.
mounica
  • 1
0
votes
0 answers

How to get stored procedure code from the database?

Is it possible to use SchemaCrawler to retrieve a stored procedure's code? I tried Routine.getDefinition() but it returned an empty string. UPDATE: Here is my code: import java.sql.Connection; import java.sql.SQLException; import…
Gili
  • 86,244
  • 97
  • 390
  • 689
0
votes
1 answer

Get stored procedures using SchemaCrawler

When I try to retrieve stored procedures from an SQL Server database using the SchemaCrawler API, I get this error: 12:28:07.427 [main] INFO schemacrawler.crawl.SchemaCrawler - Retrieving routines 12:28:07.767 [main] WARN …
Gili
  • 86,244
  • 97
  • 390
  • 689
0
votes
1 answer

SchemaCrawler couldn't connect to Oracle base

Schemacrawler couldn't connect to Oracle base. The cmd line is below: java -classpath ../../_schemacrawler/lib/*;lib/* schemacrawler.Main -url=jdbc:oracle:thin:@localhost:port:sid -u=user_name -password=pw -infolevel=minimum -schemas=target_schema…
JulJ
  • 107
  • 1
  • 1
  • 8
0
votes
2 answers

Schemacrawler cannot retrieve table in SQL Server

I cannot retrieve tables in SQL Server 2012. Using the API, I cannot get any table. If I set schema support to false, I get the table, but no columns: SchemaCrawlerOptions options = new SchemaCrawlerOptions(); …
jersey-city-ninja
  • 1,038
  • 11
  • 23
1 2 3 4 5
6
7 8