What are Macromedia developers out there using for ER diagraming? For small projects (meaning a few tables), I just use text files and write the SQL by hand. For larger projects, I have actually used UML tools with some success, and more generic tools like OmniGraffle. Last night, I decided I wanted something more sophisticated, however, that could generate SQL for me, so I downloaded a tool called XERD for OS X. So far, I’m pretty impressed with it, though I haven’t generated any SQL with it yet, which I believe will be the true test. I like the fact that it’s simple and streamlined, serving just this one specific purpose, and that it supports multiple databases (MySQL, Oracle, PostgreSQL, Sybase, and OpenBase).
What other tools are people using, for Windows, OS X, Linux and Solaris?