Oracle has released MySQL Workbench 6.0 with a redesigned user interface and new features designed to allow users to simplify MySQL database development, design, and administration.
- The Essential Guide to IT Transformation
- Consolidation: The Foundation for IT Business Transformation
MySQL Workbench sets itself out as a route for developers and data architects (that definition can include DBAs for the purposes of this explanation) to visually design, model, generate, and manage databases.
It includes data modeling tools for creating complex ER models and forward and reverse engineering. It also has features for performing difficult change management and documentation tasks. This is all about making it easier to work on multitasking database management and development.
A vertical query results mode allows query results to be visualized as a column/value pair list, which should be well suited for queries that produce few rows but many columns. A cascaded
DELETE statement generator automatically performs the "tedious task" of creating
DELETE statements for deleting a row referenced by foreign keys.
VP of MySQL engineering at Oracle Tomas Ulin has said that MySQL Workbench 6.0 also features improved visual entity-relationship model synchronization with live schemas, making the integrated database modeling tool "even more useful" for managing schemas. A new Schema Inspector provides a suite of detailed views of all objects in the schemas plus access to table maintenance operations such as
According to Oracle, "New Table Data Search: enables a text search on any number of tables and schemas for rows matching a given pattern. [There is also] wizard based migration support for Microsoft SQL Server, Sybase Adaptive Server Enterprise (ASE), PostgreSQL, and now with additional support for Sybase SQL Anywhere and SQLite."