Channels ▼
RSS

Database

New Design For MySQL Workbench 6.0


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.

More Insights

White Papers

More >>

Reports

More >>

Webcasts

More >>

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 ANALYZE and OPTIMIZE TABLE.

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."


Related Reading






Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

 
Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.
 

Video