MySQL Workbench OSS 5.1.18

MySQL Workbench OSS 5.1.18 is a perfectly designed program which enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases.

It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.

MySQL Workbench is available on Windows, Linux and Mac OS. MySQL Workbench simplifies database design and maintenance, automates time-consuming and error-prone tasks, and improves communication among DBA and developer teams. It enables data architects to visualize requirements, communicate with stakeholders, and resolve design issues before a major investment of time and resources is made.

It enables model-driven database design, which is the most efficient methodology for creating valid and well-performing databases, while providing the flexibility to respond to evolving business requirements. Model and Schema Validation utilities enforce best practice standards for data modeling, also enforce MySQL-specific physical design standards so no mistakes are made when building new ER diagrams or generating physical MySQL databases.

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. All SQL code is automatically generated and runs right the first time, which eliminates the normal error-prone process of manually writing complex SQL code.

MySQL Workbench also enables you to reverse engineer an existing database or packaged application to get better insight into its database design. Not only can MySQL Workbench forward and reverse engineer existing databases, but it can also import SQL scripts to build models and export models to DDL scripts that can be run at a later time. MySQL Workbench is offered in a free and Open Source (GPL) OSS edition and a Standard Edition as an annual subscription.

Major Features:

1. Visual Data Modeling
   • ER Diagramming  
     
   • Complete entity-relationship diagramming  
   • Choice of Diagramming Notation
     
   •  Choose from popular modeling notations  
   • Auto Layout  
   • Automatically arrange large models  
   • Model Tables, Indexes, Views  
   • Manage all MySQL data-related objects  
   • Model Stored Procedures, Triggers, Functions  
     
   • Manage all MySQL code-related objects  
   • Model User Security  
   • Manage MySQL security privileges in model  
2. Reverse Enginnering
   • Reverse Engineer from SQL Script  
   • Create models from SQL text scripts  
   • Reverse Engineer from Live Database  
   • Create models from live databases  
3. Forward Enginnering
   • Forward Engineer to SQL Script  
     
   • Generate DDL that runs right the first time to a SQL script  
   • Forward Engineer to Live Database  
   • Generate a complete physical database from a model  
     
   • Schema Synchronization
4. Schema Diff  
   • Understand the differences between a model and a live database or SQL script  
   • Schema Synch to SQL Script
   • Automatically update a model or SQL script in either direction  
   • Schema Synch to Live Database  
   • Automatically update a model or live database in either direction  
5. Schema & Model Validation
   • General Schema Validation  
   • Enforces data modeling best practice standards and eliminates common modeling errors
   • MySQL-specific Schema Validation  
   • Enforces MySQL-specific design standards and ensures physical schemas are built correctly the first time      
   • Model Validation  
   • Ensure model is free from errors      
6. DBDoc
   • Document database schemata  
   • Automate documentation of databases      
   • Document all SQL object types  
   • Include information about all aspects of a database or model      
   • Document output in multiple formats  
   • Publish in HMTL, PDF, or text      
7. Utility Functions
   • Unlimited Undo/Redo  
   • Easily undo unwanted operations and redo mistaken undo actions  
   • Import from DBDesigner4  
   • Easily import models from DBDesigner4  
   • Advanced Find  
   • Easily find search criteria in large models      
   • Export Model Diagrams  
   • Easily export as PNG, SVG, PDF, Postscript  
   • Print Model Diagrams  
   • Easily print diagrams  
8. Scripting & Plugins
   • Generic Runtime  Environment  
   • Fast performance and easy portability  
   • Lua Shell with Debugging Palettes  
   • Customize MySQL Workbench  
   • User Plugins  
   • Extend MySQL Workbench with plugins  
9. Commercial Subscription
   • Self Help Support using Knowledge Base  
   • Learn tips and techniques from the experts      
   • Software Upgrades, Updates, Fixes  
   • Get the latest upgrades and fixes