Stack Overflow
Stack Overflow

Questions tagged [schemaspy]

SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format.

SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format.

44 questions
2
votes
1 answer

How to get SchemaSpy to connect to MS SQL Server with jTDS

The database I'm trying to connect to is "DEV_A" in the following picture, I'm trying to get SchemaSpy to connect to it using jTDS. How do I shoehorn these pieces: dbs02 ms_2012 DEV_A into these args that SchemaSpy/jTDS is asking me…
Jeff Roe
  • 3,147
  • 32
  • 45
2
votes
2 answers

Generate ER diagram from postgresql database [SchemaSpy]

Anyone use this tool? I wanted to generate a ER diagram from my database. I run SchemaSpy like this: java -jar schemaSpy_5.0.0.jar -t pgsql -db mydb -host localhost -dp /home/katie/downloads/postgresql-8.0-312.jdbc3.jar -noschema -u postgres -o…
Katie
  • 3,517
  • 11
  • 36
  • 49
2
votes
1 answer

Schemaspy export?

I'm searching a way to draw a diagram for the complex database of my project. I found schemaspy by the question here, and it fits my need except for one thing: my database is quite complex so that it made a lot of arrow intersections, which make it…
Hoàng Long
  • 10,746
  • 20
  • 75
  • 124
1
vote
1 answer

SchemaSpy providing Graphviz errors/warnings

I am running SchemaSpy and am able to produce graphviz summaries, but receive two repeated errors/warnings. Here is a sample of the output from my run: INFO - Starting Main v6.2.2 on DESKTOP-43FMD5O with PID 17072…
tylerFurman
  • 11
  • 2
1
vote
2 answers

Failed to generate Table diagram -- RelationShipDiagramError (SchemaSpy - GraphViz)

Trying to create the DB schema ER Diagram using the below command but unable to generate the ER diagrams sue to some issue with graphViz configurations. schemaSpy is creating the html based file of all the tables and .dot files also being created…
iUbaid
  • 313
  • 2
  • 16
1
vote
1 answer

SchemaSpy 6.1.0 is not available on Maven central?

I try to find it on Maven Central, but the best I can find in version 5.0.0 under net.sourceforge.schemaspy groupId. I wonder if it could be available soon or later under it. Is any one has a clue why the new project under github is not pushing it…
Tony Chemit
  • 1,175
  • 4
  • 14
  • 30
1
vote
2 answers

SchemaSpy Testcontainers. Copy results from the container

I want to run SchemaSpy container against PosgtreSQL database to generate the documentation. Here is the approach I came up with: Start PostgreSQL. Start SchemaSpy with overridden entrypoint (/bin/sh). Run execInContainer to run the SchemaSpy app…
Semyon Kirekov
  • 1,237
  • 8
  • 20
1
vote
1 answer

How can I make schemaspy work with SQL Server 2016 (v13)?

last I used schemaspy was with SQL Server 2005 or 2008 in 2017. I tried it against a SQL Server 2016 (v13) instance and I can't find a jar file for the database connection that will work.
Dean-O
  • 1,143
  • 4
  • 18
  • 35
1
vote
0 answers

Editing SchemaSpy Layout files

I am currently using SchemaSpy to document databases and it is working fine. However, there are some things within the generated HTML that I do not want, thus I opened up the jar file and edited the template pages within /layout to remove the parts…
Axieof
  • 46
  • 5
1
vote
2 answers

Java Runtime Error with class file version error

I've downloaded just about every JDBC driver version I can find along with multiple versions of JAVA. Everytime I try to run SchemaSpy I get the following error: Exception in thread "main" java.lang.reflect.InvocationTargetException at…
texnoob
  • 173
  • 8
1
vote
1 answer

SchemaSpy - Connection Failure

I want to visualise my data base and tried using SchemaSpy, but I can't connect to the data base. It's a mysql data base, running on my computer, accessible under localhost and I called SchemaSpy with the following command: java -jar…
codeCre8or
  • 11
  • 1
1
vote
1 answer

how can i solve this error in schemaspy

at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) ERROR - mssql08 (The system cannot find the file specified) java.io.FileNotFoundException: mssql08 (The system cannot find the file specified) at…
Alex shakur
  • 21
  • 3
1
vote
1 answer

Is Schemaspy secure for using with sensitive data?

I'm currently looking at metadata solutions for Microsoft SQL Server 2016. I'm interested in using Schemaspy. I think it looks like a great free way to document metadata, but I'm worried that it may not be secure for use in a company with sensitive…
Tom
  • 95
  • 5
1
vote
1 answer

Printing ERD from SchemaSpy output

We have quite a large database schema and our business analysts would print it and take it to meetings. Is there any way to get schema spy to print an ERD to 1 A3 page?
Burt
  • 7,680
  • 18
  • 71
  • 127
1
vote
1 answer

SchemaSpy for SQL Server using nightly build

I would like to automate SchemaSpy as part of a nightly build against a SQL Server database. I am unsure exactly how to go about this as there seems to be java sql server drivers missing when I go to generate. Could anyone give me a step by step run…
Burt
  • 7,680
  • 18
  • 71
  • 127
1
2
3