Perhaps this will help:

https://wiki.gnome.org/Apps/Dia/Links

You might also take a look at DbVisualizer. It run across windows, Mac, Linux and Unix. Last time I looked it had both a free and commercial version.

http://www.dbvis.com/

Regards,

LelandJ



On 02/12/2014 08:15 AM, Kevin Cully wrote:
Hello,

I'm wanting to do some work with getting a SQL Schema into Dia to get some ERD/UML type work done. My client won't pay for the commercial tools. There are several tools in the Open Sourced arena, but they are pretty much designed to work with MySQL and I'm interested in PostgreSQL. I'm having trouble getting them running with my versions of Python or Perl.

What I can't seem to find is an example of the XML uncompressed output that Dia can import. I'd love to look at it and see what I would need to produce to get it to import into Dia.

** Could someone run one of the scripts for me and post back (somewhere) the uncompressed XML output that works with Dia? A table or two in the XML output would be fine as examples.

Here are some example projects:

=> Windows program but I keep getting "Problem reading sql create script file" SQL2Diagram: http://sourceforge.net/projects/sql2diagram/?source=recommended

=>Python script for turning MySQL SQL into Dia XML but there's some python error in the script: https://shiftlock.wordpress.com/2009/11/22/make-database-diagrams-in-dia-automatically/

=> Perl script for MySQL to Dia but I'm having troubles with it and the DBI.pm:
http://sourceforge.net/projects/sql2dia/

=> phpMyAdmin is supposed to have an export that will work with Dia but I can't find it and the normal XML output isn't what Dia is looking for.

Thanks for any help.
-Kevin


[excessive quoting removed by server]

_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/52fb93a2.5090...@mail.smvfp.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to