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

Schemacrawler is not fetching the data from oracle

I tried to fetch Mysql table details as below, it is fetching all the table detail but it is not fetching any data from oracle using below sc commands. Is it required any additional configuration for oracle. MySql sc -driver=com.mysql.jdbc.Driver …
Venkatesan
  • 1
0
votes
1 answer

Create SchemaCrawler diagram without descriptions

I use SchemaCrawler to create database diagrams. The source is an Oracle database where the tables and columns do have a COMMENT set. Alas the text from the COMMENT does show up in the diagram which makes the diagram huge and barely unreadable.…
Adrian B.
  • 4,333
  • 1
  • 24
  • 38
0
votes
1 answer

Schema Diagram is not generating using Schemacrawler

I am trying to generate a schema diagram using Schemacrawler but it is generating empty png file. I couldn't find the problem. Below are the command is used: call java -classpath ../../_schemacrawler/lib/*;lib/* schemacrawler.Main…
Venkatesan
  • 1
0
votes
1 answer

Way to visualize schemacrawler output in web application

Can anybody suggest a good way to visualize schemacrawler output in a webapplication. I need the output as ER diragram. is there any good javascript or jquery plugin which uses DOT format? One more thing when i try to get the output in the dot…
Khader M A
  • 5,423
  • 3
  • 19
  • 19
0
votes
1 answer

SchemaCrawler mysql json output does not include parameter names

I am testing SchemaCrawler in command line mode, but I'm unable to get the stored procedure parameter names in the json output. The parameter names are visible in the html output, but do not appear in the json for the same settings. Command…
Jeremy Hall
  • 3
  • 1
0
votes
1 answer

schemacrawler not showing relationships/edges in graph option for MS sql server db

I have been trying to graph the relationships in a subset of tables in a SQL Server db. I run sc.sh on a MAC OS using the following options: -server=sqlserver -host= -database= -user= -password= -infolevel="maximum"…
Thomas Pe
  • 3
  • 1
0
votes
1 answer

How to make Schemacrawler work with Informix 11.70 database

I've copied the Informix jar to the schemacrawler/lib ifxjdbc.jar ifxjdbcx.jar ifxlang.jar ifxlsupp.jar ifxsqlj.jar ifxtools.jar I've change the jdbc connection in ApiExample.java to Informix jdbc connection string, and the username and…
user3737906
  • 89
  • 1
  • 9
0
votes
1 answer

Not able to connect to MSSQL using Schemacrawler

I have installed Java 8 and I have the SchemaCrawler folder on E: on my machine. I run SQL Server 2012. The cmd command used is below sc.cmd -c graph -host=10.52.136.168 -user=sa -database=MyDBName schemacrawler.Main -infolevel=detailed…
mhn
  • 2,660
  • 5
  • 31
  • 51
0
votes
1 answer

Schema Crawler slow performance

I am using SchemaCrawler 8.17 for Oracle and MSSQL. The code is implemented in Java. I have following issues : Taking too much time for Oracle database. Unable to find schema for MSSQL database. I tried using INFORMATION SCHEMA VIEWS also to…
Neo
  • 93
  • 1
  • 12
0
votes
1 answer

How do I get SchemaCrawler to export actual table row data to the text output?

How do I get SchemaCrawler to export actual table row data to the text output? I can't find a example anywhere, nor documentation that refers to this option, although I have seen references on the internet implying that it can be done. I am able…
djangofan
  • 28,471
  • 61
  • 196
  • 289
0
votes
1 answer

Can't connect SchemaCrawler to SQL Server

I've downloaded SchemaCrawler for the express intent of creating a database diagram for a SQL Server 2008 R2 database. The details of my database (in SQL Server language) are: Server Name: localhost\SQLI03 Database Name: …
Ashby
  • 583
  • 9
  • 20
0
votes
1 answer

Dot graph generation too long around 60 edges

I tried to get a MPD from an Oracle database using SchemaCrawler. This tool generated a dot file and then use dot to generate the graph. But after an hour, the processing still didnt finish so I tried to launch myself dot on my dot file with the…
Albaku
  • 82
  • 8
0
votes
1 answer

Schema Crawler issue in sc.sh

I am trying to get a text dump of Oracle Database schema using SchemaCrawler utility from SourceForge. Supplied the below args at command line ./sc.sh -driver=oracle.jdbc.driver.OracleDriver -host= -port= -database=iknowit…
HungryForKnowledge
  • 289
  • 1
  • 8
  • 18
0
votes
1 answer

Schemacrawler ignore schema that can't be accessed

I am currently using Schemacrawler to gather information about various databases. The issue I am having is that the user which the application runs under doesn't have access to every database. If I attempt to retrieve the list of…
Paul Adams
  • 75
  • 1
  • 5
-1
votes
1 answer

SchemaCrawler Row Count with Velocity template?

Is it possible to get table row count with velocity template? If anyone has done it before can you share howTo? Thanks in advance.
ighori
  • 1
  • 2
1 2 3 4 5 6
7
8