Thread: database2uml software
is there a sofftware that can convert my database into a uml or into a simple graphic with all my table and connections? thanx in advance
Don, Try postgresql_autodoc-1.01.tar.gz I have been using it and it is great. It creates a dia file. Of course all the boxes/tables are on top of one another and you manually have to organize the layout. The only really problem is that the referencial integrety relationships are a type of line that you can't insert a bend or curve into. But its is still a really sharp tool. Phillip Allen Don Patou wrote: >is there a sofftware that can convert my database into a uml or into a >simple graphic with all my table and connections? > >thanx in advance > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > >
> Don, > > Try postgresql_autodoc-1.01.tar.gz I have been using it and it is great. > It creates a dia file. Of course all the boxes/tables are on top of > one another and you manually have to organize the layout. The only > really problem is that the referencial integrety relationships are a > type of line that you can't insert a bend or curve into. But its is > still a really sharp tool. > > Phillip Allen ok thanx it looks great but I don't how to use perl script with pgsql (cause it's a *.pl file right?). could you tell me how to use it please? thanx in advance
Hi Don, Don, You can use the postgresql_qutodoc as follows: Usage: postgresql_autodoc.pl [options] [dbname [username]] Options: -d <dbname> Specify database name to connect to ) -f <file> Specify UML (dia) output file -F <file> Specify index (HTML) output file -h <host> Specify database server host -p <port> Specify database server port -u <username> Specify database username --password=<pw> Specify database password --no-index Do NOT generate HTML index --no-uml Do NOT generate XML dia file --no-docbook Do NOT generate DocBook SGML file(s) --no-dot Do NOT generate directed graphs in the dot language (GraphViz) For example if your dbname=test, and username=user and password=pass you can run the script like this (in the directory that you have the file on it) ../postgresql_autodoc.pl -d test -u user --password='pass' -F test.dia this will create the UML file test.dia in the same directory to get more help on running the postgresql_autodoc.pl you can use ../postgresql_autodoc.pl --help I hope it helps. Rosta >> Don, >> >> Try postgresql_autodoc-1.01.tar.gz I have been using it and it is >> great. >> It creates a dia file. Of course all the boxes/tables are on top of >> one another and you manually have to organize the layout. The only >> really problem is that the referencial integrety relationships are a >> type of line that you can't insert a bend or curve into. But its is >> still a really sharp tool. >> >> Phillip Allen > > ok thanx it looks great but I don't how to use perl script with pgsql > (cause it's a *.pl file right?). could you tell me how to use it > please? > > thanx in advance > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html ************************************ Rosta Farzan Laboratory for Adaptive Hypermedia and Assistive Technologies Department of Math and Computer Science CSU Hayward rosta@acc.csuhayward.edu (510) 885-4026 *************************************
Don, Check out DbVisualizer, http://www.minq.se/products/dbvis/, it's Java app. I haven't tested it with pgSQL, but used it a lot when I was forced to work with SQL Server, from my Mac in some projects. It was a free software then, and they still seem to have a "free edition". Jens Eliasson <jens@headlong.se> @ Headlong Development AB Phillip J. Allen wrote: > Don, > > Try postgresql_autodoc-1.01.tar.gz I have been using it and it is > great. It creates a dia file. Of course all the boxes/tables are on > top of one another and you manually have to organize the layout. The > only really problem is that the referencial integrety relationships > are a type of line that you can't insert a bend or curve into. But > its is still a really sharp tool. > > Phillip Allen > > > Don Patou wrote: > >> is there a sofftware that can convert my database into a uml or into a >> simple graphic with all my table and connections? >> >> thanx in advance >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 1: subscribe and unsubscribe commands go to >> majordomo@postgresql.org >> >> > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >