12 replies to this topic

[michaleq]

Has anyone know/found or even is using some sort of a Entity-Relationship Diagram building software? I don't even need advanced things, just that i could design diagrams of my database, and maybe print them later (but even that isn't needed since i can always print the screen...).
And i need on that is separate from the database system, cause i use multiple systems: MySQL, SQL Server, Oracle... Support for parsing and generating SQL would be nice, but still - i don't need much
So?

[sandbox]

I just asked a database question, and this question is similar but it has no answer, so I'm going to answer it even though it's over a year old...

DBVisualizer is an excellent free tool for this. You can view your tables, data, execute queries, and more. It was also able to draw my database schema (entity relationship diagram) with no problems. I think it can connect to many different types of databases. You just have to find the right driver for the particular database you want to connect to. For oracle I had good luck using the 'thin' drivers.

If you want to go corporate then I hear ERWin is one of the industry leaders, but their package costs a few thousand bucks.

[sunzoje]

"case studio" can be the answer to your question

[SamiFX]

Try Windev I used it before .. it's realy easy and fast .. even if you are not a programmer nor designer you'll like it

[darran]

I am not sure exactly what you are referring to. But if you are talking about class, activity, use-case diagrams, I have the tool you need. Back in my studying days, we always use this tool because it is free, and it can accurately draw out these diagrams. Very crucial to designing system solutions. The best part about this software that it is free.

http://staruml.sourceforge.net/

The interface look a little like Visual Studio though.

Edited by darran, 10 April 2007 - 12:21 AM.

[iGuest]

ERdiagram
Freeware Entity-relationship Diagram Software...

What is entities relationship diagram discuse in detail.

-reply by avinash singh

[jlhaslip]

Here is one the will Import the MySql Database if you have one already built.

http://fabforce.net/

I haven't used it (yet) but might give it a try soon.

[ErdCreator]

hi try my software ErdCreator .it opensource,portable and easy to use.
http://www.erdcreato...a.org/index.php

[Quatrux]

The best diagrammer for me is the one I use and it's free and very convenient, with it it seems you can draw almost anything:

http://www.yworks.co..._yed_about.html

It's programmed in Java and is very easy to use, with the properties you can almost do anything, as I need to draw lots of diagrammers, it's the best I found for free.

For database diagramming and exporting it to sql for different DB systems I use Powerdesigner at my workplace, it costs a lot, but it's really good for drawing data models which you can transform to physical.

[mrcodealot]

Trying out MS Visio right now. Hopefully it is easy to use.