Obviously, it’s been ages since I’ve had to do any formal database design work. My benchmark? I was totally unaware that you could no longer reverse-engineer or modify databases using Visio. Hasn’t been possible since, oh, something like Visio 2003.
(Aside: you can still use older versions of Visio to modify SQL Server 2005 databases, just expect a ton of (apparently harmless) error messages if you use the built-in SQL Server drivers. I’m led to believe that the ODBC driver will do it just fine, too. Thank whomever for legacy support for 16-bit technology, eh? Good luck finding a legal obsolete version of Visio, though.)
So I installed a 90-day trial of Visual Studio 2008 Team System. ‘Coz, you know, it includes the latest MS SQL development tools.
…a 4GB download.
So I can export a database diagram I’ve already created to a format that, oh, I CAN SHARE WITH A CLIENT!
And, as it turns out, you still can’t actually export the database diagram in any form than a SQL script. Fortunately, we had an ancient version of Visio lying around the office. But damn…
(And don’t get me started on Apple, Sun, or the vast preponderance of Open Source stuff, either. Right now, I hate ’em all. Computers. Software. Programmers. Hmph.)