[. . . ] MySQL Workbench 5. 1
Visual Database Design on Windows, Linux, MacOS
"MySQL Workbench SE is a powerful visual design tool. [. . . ] All objects can be modeled and maintained inside of MySQL Workbench including tables, indexes, views, stored procedures, triggers, and security privileges.
MySQL
MySQL Workbench is offered in the following Editions: s MySQL Workbench Community Edition available under the open source GPL license. s MySQL Workbench Standard Edition requires purchase of annual subscription. Includes additional modules and plugins to improve DBA productivity.
MySQL Workbench Community GPL Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes MySQL Workbench Standard Commercial1 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
WORKBENCH Forward and Reverse Engineering
MySQL Workbench provides capabilities for forward engineering of physical database designs. A visual data model can easily be transformed into a physical database on a target MySQL Server with just a few mouse clicks. MySQL Workbench also enables you to reverse engineer an existing database or packaged application to get better insight into its database design.
Software License Visual Data Modeling ER Diagramming Choice of Diagramming Notation Auto Layout Model Tables, Indexes, Views Model Stored Procedures, Triggers, Functions Model User Security Reverse Enginnering Reverse Engineer from SQL Script Reverse Engineer from Live Database Forward Engineering Forward Engineer from SQL Script Forward Engineer from Live Database Schema Synchronization Schema Diff Schema Synch to SQL Script Schema Synch to Live Database Schema & Model Validation General Schema Validation MySQL-specific Schema Validation Model Validation DBDoc Document database schemata Document all SQL object types Document output in multiple formats Utility Functions Unlimited Undo/Redo Import from DBDesigner4 Advanced Find Export Model Diagrams Print Model Diagrams Scripting & Plugins Generic Runtime (GRT) Environment Lua Shell with Debugging Palattes User Plugins Commercial Subscription2 Self Help Support using Knowledge Base Software Upgrades, Updates, Fixes
Change Management
Database change management is a difficult and complex process, which involves maintaining different versions of database schemas and manually modifying existing databases. To help DBAs and developers with change management, MySQL Workbench includes Schema Synchronization and Comparison utilities.
Database Documentation
Documenting database designs can be a time-consuming process. [. . . ] Other products mentioned are the trademarks of their respective corporations. [. . . ]