tedia2sql - Dia ERD (UML class) diagrams to DDL (SQL)

andreas1234567 has asked for the wisdom of the Perl Monks concerning the following question:

I recently stumbled upon tedia2sql by Tim Ellis et al. It "[..] allows you to create a database ERD in Dia (using the UML shape toolset), then to convert that ERD into a SQL DDL script for multiple databases." Basically it's a giant GPL'ed Perl script. I'm very excited that both Dia and tedia2sql are GPL open-source, and further delighted that it supports a multitude of database engines, including MySQL, PostgresQL, Oracle, DB2, Ingres and SAS. Then, I noticed

The last version (1.2.12) of tedia2sql is more than 3 years old, which left me to speculate whether it's still maintained.
There are bugs not acted upon, e.g. here (bugs.debian.org).
There's no test suite.
The mailing list shows no indication of further development, in fact, the author himself writes in this post:
As much hard work as we've all put into this project, we must admit tedia2sql was just a hack, and a day like this was inevitable. Thanks to everyone who used/supported/wrote tedia2sql, and let's hope it really can die soon. :)

I noticed 2 alternative ERD to DDL tools on the mailing list above:

What's your view on tedia2sql? How does it compare to the alternatives?

--
Andreas

Comment on tedia2sql - Dia ERD (UML class) diagrams to DDL (SQL) - opinions and options

Replies are listed 'Best First'.
Re: tedia2sql - Dia ERD (UML class) diagrams to DDL (SQL) - opinions and options by Anonymous Monk on Jan 31, 2008 at 22:06 UTC
I just started using tedia2sql today to generate some Oracle DDL. I love it, and I even started customizing it to adjust foreign key constraint names and output for sequences. I was trying to find something to convert visio 2003 to ddl but I came to the conclusion that there was nothing free or open source that could do this. Then I stumbled upon tedia2sql what a life saver.	[reply]
Re: tedia2sql - Dia ERD (UML class) diagrams to DDL (SQL) - opinions and options by andreas1234567 (Vicar) on Dec 10, 2008 at 10:47 UTC
Update December 2008: It seems the original maintainer of the project, Tim Ellis, has stepped down. Fortunately, Mike Ginou, has (during fall of 2008) stepped up and applied a number of patches. However, he writes he's sadly, not able to put any time towards tedia2sql. Nevertheless, he has applied a number of patches to the cvs repository and been active on the mailing list (web archive) since then: `$ cvs log tedia2sql \| grep '2008' -B1 revision 1.73 date: 2008/11/27 03:01:59; author: mginou; state: Exp; lines: +2 -2 -- revision 1.72 date: 2008/11/26 11:49:45; author: mginou; state: Exp; lines: +2 -2 -- revision 1.71 date: 2008/11/26 11:47:25; author: mginou; state: Exp; lines: +17 - +30 -- revision 1.70 date: 2008/11/26 11:39:36; author: mginou; state: Exp; lines: +13 - +1 -- revision 1.69 date: 2008/11/26 03:35:58; author: mginou; state: Exp; lines: +3 -0` [download] Citing this thread: Open Source projects never die - they just sleep until a new maintainer pops up :-) So: If anyone feels like contributing to this (perl) project, or even make it into a CPAN module (it is GNU GPL, after all :), this is the time. `cvs -d :pserver:guest@cvs.tigris.org:/cvs checkout tedia2sql` [download] Update Wed Dec 10 12:17:13 CET 2008 : Added links and cvs log and checkout. -- No matter how great and destructive your problems may seem now, remember, you've probably only seen the tip of them. [1]	[reply] [d/l] [select]