Other databases are nice, but 99% of our DBs are SQL Server, and most of them are 2000, with a few 2005. There are times when I just want to throw diagrams around, possibly of half-finished designs, and refine them with others until we're ready to instantiate the real database. This is my major reason for not just using SSMS's diagramming. I've looked around on StackOverflow, and the only close match to my question I could find wasn't very encouraging. My only real experience with this product category is very old (like, ER/Studio a decade ago), so I have no idea what the landscape looks like today. ![]() But I'd really like to find a better, less painful, more sustainable solution. Since the designs are generally pretty small, that pain hasn't gotten too bad. This is pretty painful, though, because there's no good way to get the data out of Visio (though this answer gives me hope of a temporary analgesic). ![]() In the past, I've used Visio (2003 Professional, if it matters) to doodle database diagrams while we're in the conceptual design phase.
0 Comments
Leave a Reply. |