Hello, List,
About two months ago, I created a script to take a Dia ER diagram and
automatically create SQL DDL for the database. At first, this supported
only PostgreSQL, Oracle, Sybase, and IBM DB2. However, a stated goal of
the project was to support other databases. This script has created what I
would characterise as enormous response. There is now an active mailing
list, CVS, fairly-often releases, etc.
This past weekend, a MySQL DBA (Martin Gebert from... Germany?)
contributed the code necessary to generate MySQL InnoDB database tables,
so I'm announcing the tool's availability here.
The tool is called tedia2sql.
Homepage:
http://tedia2sql.tigris.org
Screenshots:
http://tedia2sql.tigris.org/sampleImages/BigERD.png
http://tedia2sql.tigris.org/sampleImages/TestERD.png
Generated InnoDB SQL from Screenshot #2:
http://tedia2sql.tigris.org/innodb-testerd.sql
I've been told the documentation is good, so you might look at it to see
if tedia2sql can help you out.
It is worth noting, if you examine the SQL, that the script is simply
generating the SQL as the database diagram calls for. The database diagram
(screenshot #2) was designed for a PostgreSQL / Oracle / DB2 target. Thus
it includes views (which I understand MySQL doesn't support) and doesn't
have some of the required foreign-key indexes on tables (which non-MySQL
targets do not mandate).
This tool should make DBAs excited, and I hope it amuses at least a couple
of you.
--
Tim Ellis
Senior Database Architect
Author, tedia2sql (http://tedia2sql.tigris.org)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
