• Back to Project

Comments for SchemaSpy

I use the project several times a day. We have a multt TB SQL Server db w/1700 tables and over a hundred views. Its a beast, evolved over 10 years, no DTD, etc. And I'm new. Its the only sane way to explore the schema and has been a life saver coming up to speed here. Salut!

An excellent tool and one that I wish I'd found years earlier. I wrote a batch file to invoke it for a PostgreSQL schema provided on the command line:

pastebin.com/cV8fXaJm

I got it to work under Ubuntu 9.10 with postgresql 8.4, I need to create this element : information_schema._pg_keypositions()

I found the solution here : forum.hibernate.org/vi...

I need this file too : postgresql-8.0-312.jdbc3.jar (available here : www.findjar.com/jar/po...)

Thanks for this great piece of software

Cesium5500

well done.

Hurray!
I love SchemaSpy -- I am so glad to see that it's being updated. This is a great tool. Excellent execution. Thank you so much for making this available!

Re: Fantastic database mapping tool!
Post the details of the failure in the help forum (sourceforge.net/forum/...) and we should be able to figure it out.

Re: Fantastic database mapping tool!
where are the debugging notes for Jdbc -cp jar file issues?

I have a successful command line into the PostgreSql instance but running this with the command line will not invoke without error. Any ideas?

java -jar schemaSpy.jar -t pgsql -db mydb -host localhost -port 6432 -u user -p password -o postgresql_schema

I even tried adding the -s name as 'public' and no luck either.

First ever ...
... tool I found that "digest" a vintage Sybase database without a glitch ... Hey ... GREAT job. Thank you.

Re: Fantastic database mapping tool!

> Produces very attractive graphical

> representations of your database schema.

> Works well with postgres 8, and is

> generally quite impressive. Give it a

> try.

Thanks Jason. Note that I really appreciate any/all feedback. If there's something that anyone would like to see added then tell me about it on the SourceForge site. I want to make SchemaSpy as useful as possible.

Fantastic database mapping tool!
Produces very attractive graphical representations of your database schema. Works well with postgres 8, and is generally quite impressive. Give it a try.