I have been trying to get hold of ERWin for a long time now and have pretty much given up. What would you recommend as a modeling tool that supports forward /reverse engineering (with DB2 support), and where can I get hold of it? What would be the preferred tool, forgetting cost... and what would be the cheapest alternative?
A lot depends on why you've given up on getting a copy of ERWin.
ERWin still exists, and is currently sold by Computer Associates (http://www3.ca.com/Solutions/Product.asp?ID=260). You can purchase it though The Programmer's Shop (http://www.programmersparadise.com/index.pasp) and many other sources.
Although I'm often frustrated by ERWin, I always go back to it. It is the grand-daddy of the current generation of data modeling tools, and has just about every feature known to man. Computer Associates is not my favorite vendor, but they do buy very good products and expose those products to larger markets.
The cheapest alternative that I can recommend is Visio Architect, which is including in Microsoft's Visual Studio .NET Enterprise Architect (VESA). While this isn't "cheap", it is usually already owned by people that need to do data modeling. If you already own VESA, that makes the modeling tool essentially free.
There are a number of other modeling tools. Sybase PowerDesigner is a good choice. Rational markets a great modeling tool as part of their suite (very expensive, but very good). Oracle also markets a modeling tool, although I've never had good luck with it.
For More Information
- Dozens more answers to tough database design questions from Pat Phelan
- The Best Database Design Web Links: tips, tutorials, scripts, and more
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your database design questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.