Recommendation for a good entity relationship diagram building tool for occasional usage ?

Question

Freeware is a plus. Could you also describe with one sentence why it should be good enough for occasional usage?

Edit: You might check this cool link , providing more info about entity relationship diagrams and tools

Edit: For the chosen answer couple of tips - click on entity even it looks like circle and type the name and Enter - it will give you the Entity box - Click on association , Ctrl + L would give you the nice line

Answer 1

Oracle Data Modeling - works with Oracle, MsSQL and DB2

MySQL Workbench - works with MySQL

Answer 2

Try Dezign for Databases. It's very easy to use (but powerful enough for most development tasks, supports a wide range of databases and finally the price (~245 $) is not that much. Personally I'm very happy with the tool.

Answer 3

Toad Data Modeler - costs 400 USD, but is worth the price. Currently it offers many nice features, and they are still adding more. There is an excellent user community around this tool, and it is quite easy to stay in touch with development team.

Answer 4

You can use StarUML with the ER extension. It is totally free, stable and easy to learn.

Answer 5

Dbdesigner 4 at http://www.fabforce.net/dbdesigner4/downloads.php. It's free, easy to use, does reverse engineering.

Answer 6

In case you are using Visual Studio - it has it's own diagram tool integrated. Works good enough for me.