While investigating tools for generating ER Diagrams for the data warehouse I’m working on I came across this good article on databasejournal.com which compares three of the top CASE (computer aided software engineering) tools for Oracle.
In the article Steve Callan quickly highlights the differences between Microsoft Visio 2003, Oracle Designer and AllFusion ERwin Data Modeler.
What can we take home from this article? Well, Microsoft Visio is (relatively) cheap at $499 and has good reverse engineering abilities, but won’t write database creation code for you.
Oracle Designer is clumsy, but since it’s bundled with Internet Developer Suite you might already own it; otherwise you’re probably not likely to justify the $5,000 cost of entry.
ERwin really seems like the Cadillac solution for database modeling. The $3,995 price tag will put off most, but like they say in the auto industry, if you’re worried about gas mileage you’re not ready for a Cadillac.