Open Source Data Modeling Tools?

[JimTDI]

Hi Everyone!

Are there any good data modeling (database designing) tools that anyone can suggest or recommend.

How about for the Eclipse/Java environment - is there a plugin that will allow me to visaully design ERD diagrams and generate CREATE and DROP SQL ??

Thanks!

[marianom]

Must it be open source or free can do the trick too?

[lloyd mcclendon]

www.hibernate.org look into hbm2ddl auto update for your database schema. i haven't wrote a create table statement in so long i almost forget how.

as for modeling tools, good question.

for eclipse you would think there would be something real nice but i have yet to find it. i'm looking into the ones on this page http://galaxy.andromda.org/docs/case-tools.html

also someone told me about this http://taylor.sourceforge.net/index.php/Overview

if anyone has used or evaluates any of these please post. or if you know of a good free one that isn't a piece of crap, really slow, and pretty useless please share. thanks

[prs]

How about fabFORCE's DBDesigner 4?

http://fabforce.net/dbdesigner4/

[JimTDI]

Must it be open source or free can do the trick too?

Free can do the trick too! Thank you!!

[JimTDI]

www.hibernate.org look into hbm2ddl auto update for your database schema. i haven't wrote a create table statement in so long i almost forget how.

as for modeling tools, good question.

for eclipse you would think there would be something real nice but i have yet to find it. i'm looking into the ones on this page http://galaxy.andromda.org/docs/case-tools.html

also someone told me about this http://taylor.sourceforge.net/index.php/Overview

if anyone has used or evaluates any of these please post. or if you know of a good free one that isn't a piece of crap, really slow, and pretty useless please share. thanks

Thank you for your reply! I will go take a look at these.

[JimTDI]

How about fabFORCE's DBDesigner 4?

http://fabforce.net/dbdesigner4/

Thank you! I took a look at their site briefly - they mention MySQL alot. I will take a look further - hopefully it will work with Postgresql too!

Appreciate your reply!!

[ezekielrage]

I used it and it looks like my db needs are satisfied for now.
Is there a way to request the ubuntu gods to package it?

[fredy]

SQLPOWER POWER*Architect !!!!!


try it ! *****

[glok_twen]

druid is cool.

[CostaRica]

SQLPOWER POWER*Architect !!!!!


try it ! *****

Looks great! Thanks!

[kknd]

Dia + tedia2sql!

[imblack]

Can you guys create a bottom line for new users that read this thread?

So in the end you list that this IDE is this and that is that, and I recommend that or I like that etc.

Thankyou

[Papa_Smurf]

MySQL itself has a great workbench. http://dev.mysql.com/downloads/workbench/

[imblack]

Yes MySQL workbench is really nice, you can reverse engineer already created database into diagram and convert diagram into SQL script etc.