Recently I tested two products:
EMS SQL Manager for MySQL
MySQL Workbench SE
My requirements
- Nice and easy GUI
- Reverse engineer tables
- Make virtual relations between fields
- Relationship notation that can connect to columns
- Comments on table and columns
- pdf/html report with comments
Conclusion
I choose MySQL Workbench SE because its GUI were really nice and easy to work with. It can however at times be slow and it for sure needs some more development time to make it the best. Documenting on table/fields was easy and I can also export to various formats. It do lack the virtual relationship which I hope will come in near future - until then I will create real relationships and then simply not committing back to database. Not the optimal solution but it will do for now.
EMS had the virtual relation but the GUI were not easy to work with. If EMS had a better GUI with the options to add layers and more options then perhaps it would have been my preferred app.
No comments:
Post a Comment