In my Database class this evening we were watching the instructor do some database modeling using Visio. I was playing along using Omnigraffle, but after a while it didn’t go as far as Visio did in terms of automatically creating relationships, foreign keys, and that sort of thing. I wanted something more developer oriented. So I did some quick research on what is available:
Supports MySQL, obviously. I might wind up using this just because I almost entirely deal with MySQL. The only variable in that is my forays into Oracle lately.
Aquafold Data Studio
Supports Oracle, DB2, SQL Server, Sybase, Informix, PostgreSQL, MySQL – code generation looks powerful.
Free version 4.7, 6.0 costs $399. 4.7 looks dated compared to the 6.0 version, but man the price jump!
Many interesting and compelling variations. Community Edition is free. This one looks pretty nice to me – my cup of tea. Lots of related products and editions, so there are options for most modeling needs, budgets, and scopes.
ConceptDraw VI Pro
Standard $149, Pro $299
So far I’ve cracked open MySQL Workbench and Visual Paradigm for UML Community Edition. I am only at the beginning of exploring these tools, so I’ll let you know how it turns out.