MySQL Workbench

MySQL Workbench is the application for visual design of databases as a part of which instruments of design, modeling, creation and operation of a DB.

MySQL Workbench - the successor of the DBDesigner systems 4 of FabForce is also offered in two options:

Community Edition - is distributed under the free license GNU GPL To Standard Edition - it is available on the annual paid subscription. This version includes additional functions which increase performance of developers and database administrators.

History

The first version of MySQL Workbench appeared in September, 2005 and became the first product family which is available in two editions.

Program capabilities

• Allows to present database model in the graphic form visually.
• The evident, functional mechanism of installation of cross-table relationships, including "many to many" with creation of the table of communications.
• Reverse Engineering is recovery of structure of tables from already existing on the DB server (communication is reestablished in InnoDB, when using MyISAM — connection needs to be established manually).
• The convenient editor of SQL of requests allowing to send at once them to the server and to receive the answer in the form of the table.
• Possibility of editing data in the table in the visual mode.

2013

MySQL Workbench 6.0

MySQL Workbench 6.0 is the new version of the instrument of design, development and administration of databases open source.

The release of Oracle MySQL Workbench 6.0 was announced by the press service on August 29, 2013.

Changes

• the processed graphical user interface which has the upgraded main screen and the interface for uniform, multitask management of databases and development now

• the mode of vertical display of results of requests allows to present results in the form of the list of pairs column/value.
• the generator of cascade operators DELETE automates creation of DELETE operators for line delete to which foreign keys refer.

• synchronization of visual entity relationship models with dynamically renewed schemes is improved. The new feature of Schema Inspector offers a set of detailed representations of all objects in schemes and also access to transactions of service of tables
• new means of data retrieval in tables provide text search of the lines corresponding to the set template in any number of tables and schemes
• the improved Server Status function provides short summary information on the status and a configuration of the server
• Workbench 6.0 supports migration on the basis of masters for the Microsoft SQL Server, Sybase Adaptive Server Enterprise, PostgreSQL, Sybase SQL Anywhere and SQLite.

Availability

MySQL Workbench Community Edition is distributed for free according to the license GPL.

MySQL Workbench Enterprise Edition is included in a subscription to MySQL Enterprise Edition.

Corporate edition provides additional functions, including the graphical user interface MySQL Enterprise Backup for creation of backup copies and the automated recovery and also MySQL Audit Log for data analysis of audit generated through MySQL Enterprise Audit.

2014

MySQL Workbench 6.2

On November 6, 2014 the Oracle corporation declared a release of the new version of MySQL Workbench 6.2.

New opportunities

• Migration of databases from Microsoft Access that helps users to carry out Microsoft Access data migration to MySQL.

• The Visual Explain mechanism (it is intended for visual assessment of the selected execution plan of a request) is improved that improves and simplifies setup of performance of SQL queries.

• The preview player of data of GIS, allows users to browse space data of MySQL using more powerful and the reliable "geometrical engine" (geometric engine).