Skip to main content
Database Administrators

About

Ask Question
Tag Info
Info Newest Frequent Score Active Unanswered

A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.

MySQL Workbench is a visual database design tool that is developed by MySQL. It is the successor application of the DBDesigner4 project.

You can see a video presentation here

The first preview version of MySQL Workbench was released in September 2005, and was not included in the MySQL GUI Tools Bundle. Development was started again in 2007 and MySQL Workbench was set to become the MySQL GUI flagship product. Version numbering was started 5.0 to emphasis the fact that MySQL Workbench was developed as the successor to DBDesigner4.

MySQL Workbench 5.0 and 5.1

MySQL Workbench 5.0 and 5.1 are specialized visual database design tools for the MySQL database. While MySQL Workbench 5.0 was a MS Windows only product cross-platform support was added to MySQL Workbench 5.1 and later.

MySQL Workbench 5.2

Starting with MySQL Workbench 5.2 the application has evolved to a general database GUI application. Apart from physical database modeling it features a SQL Editor, database migration tools, and a database server administration interface, replacing the old MySQL GUI Tools Bundle.

Prominent features of MySQL Workbench 5.2 are:

General

  • Database Connection & Instance Management
  • Wizard driven action items
  • Fully scriptable with Python and Lua
  • Support for custom plugins

SQL Editor

  • Schema object browsing
  • SQL syntax highlighter and statement parser
  • Multiple-, editable result sets
  • SQL snippets collections
  • SSH connection tunneling
  • Unicode support

Data modeling

  • ER diagramming
  • Drag'n'Drop visual modeling
  • Reverse engineering from SQL Scripts and live database
  • Forward engineering to SQL Scripts and live database
  • Schema synchronization
  • Printing of models
  • Import from fabFORCE.net DBDesigner4

Database administration

  • Start and stop of database instances
  • Instance configuration
  • Database account management
  • Instance variables browsing
  • Log file browsing
  • Data dump export/import

Database migration (as of 5.2.41)

  • Any ODBC compliant database
  • Native support: Microsoft SQL Server, PostgreSQL, Sybase ASE

Copied from: http://stackoverflow.com/tags/mysql-workbench/info

History Excerpt history