View Full Version : Open Source Data Modeling Tools?
JimTDI
November 24th, 2006, 05:48 PM
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
November 24th, 2006, 07:18 PM
Must it be open source or free can do the trick too?
lloyd mcclendon
November 24th, 2006, 09:33 PM
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
November 24th, 2006, 09:55 PM
How about fabFORCE's DBDesigner 4?
http://fabforce.net/dbdesigner4/
JimTDI
November 25th, 2006, 12:47 AM
Must it be open source or free can do the trick too?
Free can do the trick too! Thank you!!
JimTDI
November 25th, 2006, 12:48 AM
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
November 25th, 2006, 12:51 AM
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
October 20th, 2007, 02:33 AM
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
March 19th, 2008, 08:14 PM
SQLPOWER POWER*Architect !!!!!
try it ! *****
glok_twen
March 20th, 2008, 02:41 AM
druid is cool.
CostaRica
June 15th, 2008, 07:06 PM
SQLPOWER POWER*Architect !!!!!
try it ! *****
Looks great! Thanks!
kknd
June 15th, 2008, 08:04 PM
Dia + tedia2sql!
imblack
April 2nd, 2010, 09:40 PM
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
July 7th, 2010, 09:10 PM
MySQL itself has a great workbench. http://dev.mysql.com/downloads/workbench/
imblack
July 16th, 2010, 05:55 PM
Yes MySQL workbench is really nice, you can reverse engineer already created database into diagram and convert diagram into SQL script etc.
Powered by vBulletin® Version 4.2.2 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.