After reviewing a bunch of the data modeling tools out there, I've come to the conclusion that there are some great tools out there, some workable tools and some tools to avoid.
Data Modeling Tools Result Summary
- CA ERwin
- This is a toolset that has been in the decline for while. CA is trying to pull it out of the nose-dive it's in but it has a legacy code-base without a lot of the original team around to explain it. As a long term system I can't recommend it. It will continue to go downhill.
- Visio 2010 Professional
- Fine for small models but it will quickly become to unwieldy with a significant model. Microsoft doesn't seem interested in this aspect of the tool market and are not improving Visio for it.
- MySQL Workbench
- Stability is important. It's free but my time is not. I don't recommend this tool.
- SQL Power Architect (Community Edition)
- This tool needs better integration with the actual database. It has the most potential of any open source modeling tool I've seen.
- Embarcadero's ER/Studio Data Architect (Trial)
- This tool works flawlessly. If you can afford it, buy it. They've been doing this for over 15 years and have built an entire product line around modeling tools.
- Toad Data Modeler (Trial)
- I admit that the lack of stability irritated me greatly but I don't think that this product has improved much over the last few years and it may be on life support from Quest. Not recommended.
- ModelRight Professional (Trial)
- For the price (roughly 25% of ER/Studio) this tool works amazingly well. The only thing it lacks is logical modeling, if you have one platform (like most folks) this is a great choice.
Hello. Awesome post, because the author appears to know about the products, and is offering well-formulated opinions in an objective manner. I have used only 3 of the products he listed, and his opinions about those 3 are similar to my own. I stuck with Modelright for working with database schema modeling, because it fits that requirement set perfectly.
ReplyDeleteI would like to mention "Enterprise Architect", which I recently purchased for $199 (Professional version, although pricier versions exist). It includes an exhaustively comprehensive suite of UML modeling tools, and has excellent database modeling capabilities. I still prefer Modelright for database modeling, as they have more creature comforts built in, but use Enterprise Architect for everything else, including some initial code generation on new projects.
If I didn't already own Modelright, I would have only purchased Enterprise Architect, as it is more than adequate for database modeling and generation, and also serves my UML requirements. EA also costs less than Modelright.
Thanks for the comment Michael!
DeleteI haven't used Enterprise Architect in a while, and I agree, it is a terrifically solid tool for UML documentation. The only problem was that it lacked a way to forward-engineer the data model changes. Part of my goals were to avoid the extra book-keeping of managing the schema and documentation independently.