May 28, 2003
Data Modelling Tools
I'm in the market for a cheap (well alright, free) data modelling tool. I want one that allows me to draw pretty pictures and from the generate valid DDL that can be used to build a schema. It would be nice if if could reverse engineer existing schemas.
For added brownie points I should be able to specify a logical data model (entities, attributes and relations). For extra, extra brownie points it should allow me to link logical and physical data models.
My databases of choice are Oracle, DB2, SQL Server and MySQL. I don't mind if it doesn't support all of these out of the box, as long as I can amend the code generator for the particular quirks of each environment. Oh, and did I mention that it should be free?
I had a look at Google, but it wasn't much help.
I'd rather not write one myself, as that could take decades, but if you know of a project that is close to my needs then fire up the comments below.
Posted by Andy Todd at May 28, 2003 04:25 PM
http://www.info.fundp.ac.be/~dbm/informations.html - not fully free :-)
ArgoUML - argouml.tigris.org - it is an OSS UML tool. Might be able to write plugins that generate SQL DDL from it.
Of course, you can spend $5K and get the greatest tool out there - Oracle Designer :-)
Oh wait - there is http://tedia2sql.tigris.org/. It can generate DDL from Dia diagrams.
Thanks, I'll take a look.
I already have Oracle Designer, its just a little difficult to get it to churn out MySQL ddl though (for example).
http://pymerase.sourceforge.net/ - ArgoUML, generate PostgreSQL ddl and Python object-relational mapping code. May be you can just take the "generate SQL" part and use it?
Try the last standalone version of VisioModeller - free download from Microsoft's unsupported site.
ORM and ER support, can generate and rev. eng physical. Reasonable db suppoprt (no mysql from recollection)
Came across this from Freshmeat.net. Have not tried it, but it is OSS, Java - so extending the code base is an option.
Also take a look at http://www.alzabo.org/
Try Enterprise Architect at http://www.sparxsystems.com.au/ - UML, but also contains abiity to create DDL. I use a highly configured Sybase database (e.g. code is a user-defined type for char(4)) and I was able to output the DDL I needed in EA.
Downloading the Sybase Dev Edition of ASE also gets you a great ER tool, physical architect, as well as the useful Infomaker.
Have you seen "DeZign for Databases"?
Try Sanity from www.objectworkshop.com It is web based and free.