Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Modeling tools that support DB2 and forward/reverse engineering

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

Dig Deeper on Oracle DBA tools

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.