Data Modeling Tools
- CA ERwin (see below)
- Visio 2010 Professional
- MySQL Workbench
- SQL Power Architect (Community Edition)
- Embarcadero's ER/Studio Data Architect (Trial)
- Toad Data Modeler (Trial)
- ModelRight Professional (Trial)
I have been using ERwin for a few years now so I am pretty familiar with this tool. Like it or not it has been around for ages (Logic Works, who originally made ERwin started in 1988) and is the benchmark all other system have to be measured against.
The most recent version has not been entirely stable, I cannot make it crash on demand but it will occasionally lock up.
ERwin Data Modeler Std Edt + 1 yr Maint: ~$3,900
- Logic Modeling: Yes
- Physical Modeling: Yes
- Reverse Engineering: Yes
- Forward Engineering: Yes
- Sub Models: Yes
ERwin has the core features I'd like, but it's not entirely stable, the GUI is quirky and the product is expensive. For the price I would expect CA to be rolling updates more frequently to address these issues but ERwin has had minimal updates these last few years.