After dealing with some frustrations with EER tools in MySQL Workbench and SQLyog, I’ve turned to Toad. I like what I’ve found so far… except:
After importing tables (around 40) from a database I’m working on into the Database Diagram utility, I spent fifteen minutes arranging all of them. I wanted to ensure that the diagram presented a clean and unambiguous picture of my database and all its internal relationships. I saved off the .ter file, closed Toad, and then reopened the .ter file to find that all of my time spent arranging the tables was for naught. It just went right back to the cluttered, ambiguous mess that I started with.
Am I doing something wrong? Are my expectations too high?
For the record, SQLyog’s EER utility didn’t really work at all. And while the MySQL Workbench EER utility has a great look and feel (including maintaining all of the careful positioning of tables within the diagram), I found that it crashes far too often and doesn’t do a very good job of diffing the EER diagram with the metadata on synchronization, forcing me to edit the synch script every time I did an update.