Re: [GENERAL] Any freeware graphic display of DDL software available?

2015-05-07 Thread Rajiv M Ranganath
If you use Amazon Linux on EC2, we have packaged SchemaSpy support for it. More details are here, https://lambda-linux.io/blog/2015/05/07/announcing-schemaspy-support-for-amazon-linux/ Best, Rajiv On Thu, Jan 16, 2014 at 7:46 PM, Merlin Moncure mmonc...@gmail.com wrote: On Thu, Jan 16, 2014 at

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-17 Thread rob stone
O n Thu, 2014-01-16 at 08:45 -0800, Susan Cassidy wrote: I know about Erwin, but it is too expensive.T hanks, Susan You can try ExecuteQuery from www.executequery.org. It is written in Java so needs the JDBC driver to access the database. It cannot read a DDL script but obtains meta data

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread Karsten Hilbert
On Thu, Jan 16, 2014 at 08:45:44AM -0800, Susan Cassidy wrote: Is there any free or cheap software that will read in DDL and output a graphic display of it? Preferably showing links for foreign keys. pg_autodoc Karsten -- GPG key ID E4071346 @ gpg-keyserver.de E167 67FD A291 2BEA 73BD 4537

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread salah jubeh
Sparx architect Regards On Thursday, January 16, 2014 5:52 PM, Karsten Hilbert karsten.hilb...@gmx.net wrote: On Thu, Jan 16, 2014 at 08:45:44AM -0800, Susan Cassidy wrote: Is there any free or cheap software that will read in DDL and output a graphic display of it?  Preferably showing

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread Bartosz Dmytrak
Hi, try DBVisualizer -- Regards, Bartek

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread Paul Jungwirth
I use this script on an Ubuntu system: #!/bin/bash set -eu postgresql_autodoc -d example_dev -u example_dev -h localhost --password= dot -Tpng -o example-schema.png example_dev.dot dot -Tpdf -o example-schema.pdf example_dev.dot That gives you a schema diagram in pdf, png, dia, and dot

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread Susan Cassidy
It doesn't appear that DBVisualizer does an ER type diagram, which is what I really need. Thanks, Susan On Thu, Jan 16, 2014 at 1:09 PM, Bartosz Dmytrak bdmyt...@gmail.com wrote: Hi, try DBVisualizer -- Regards, Bartek

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread bricklen
On Thu, Jan 16, 2014 at 2:57 PM, Susan Cassidy susan.cass...@decisionsciencescorp.com wrote: It doesn't appear that DBVisualizer does an ER type diagram, which is what I really need. DBSchema outputs ER diagrams: http://www.dbschema.com/database-er-diagrams.html I think the paid version is

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread Susan Cassidy
What are the dot lines for? They don't seem to work on my Linux installation. I tried adding them to the initial line, and I see no .pdf output. I just see: Producing testdb.dia from /usr/share/postgresql_autodoc/dia.tmpl Producing testdb.dot from /usr/share/postgresql_autodoc/dot.tmpl

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread Adrian Klaver
On 01/16/2014 03:12 PM, Susan Cassidy wrote: What are the dot lines for? They don't seem to work on my Linux installation. I tried adding them to the initial line, and I see no .pdf output. I just see: Producing testdb.dia from /usr/share/postgresql_autodoc/dia.tmpl Producing testdb.dot

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread John R Pierce
On 1/16/2014 3:12 PM, Susan Cassidy wrote: What do I do with a .dot or .dia formatted file? not sure about .DOT, but .DIA is probably for the Dia drawing program, which is a simple Vizio like program, free open source. -- john r pierce 37N 122W

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread Merlin Moncure
On Thu, Jan 16, 2014 at 10:45 AM, Susan Cassidy susan.cass...@decisionsciencescorp.com wrote: Is there any free or cheap software that will read in DDL and output a graphic display of it? Preferably showing links for foreign keys. I know about Erwin, but it is too expensive. I want to give a

Re: [GENERAL] Any freeware graphic display of DDL software available?

2014-01-16 Thread Dann Corbit
graphic display of DDL software available? It doesn't appear that DBVisualizer does an ER type diagram, which is what I really need. Thanks, Susan On Thu, Jan 16, 2014 at 1:09 PM, Bartosz Dmytrak bdmyt...@gmail.commailto:bdmyt...@gmail.com wrote: Hi, try DBVisualizer -- Regards, Bartek