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


_______________________________________________
Post Messages to: [email protected]
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/[email protected]
** 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