Monday Aug 12, 2013

MySQL Workbench 6.0 - New Design and Many Enhancements

New GUI, 30+ New Features, and Major New Components

Oracle is excited to announce the immediate availability of the production-read, GA release of MySQL Workbench 6.0, available for download under the GPL, as well as part of the Commercial MySQL Standard, Enterprise, and Cluster Carrier Grade Editions with 24x7 global support.

The need by database professionals for management tools has increased with expanding data volumes, web, cloud and mobile computing growth. Improvement and additions in MySQL Workbench helps developers and administrators better manage these dynamic data environments. This latest GA release includes many new features and a modernized user interface that allows users to simplify MySQL database development, design and administration.

Overview
The goal of MySQL Workbench 6.0 is to simplify and improve the workflow in the graphical user interface (GUI) as well as adding new features and functions. The enhanced design in the multi-platform GUI not only increases usability and productivity of the tool, but also offers new database management capabilities. MySQL Workbench 6.0 improves user productivity across the board from database architects to developers to DBAs, by enhancing support for data modeling and SQL development, as well as improving and adding tools for server configuration, user administration, migration, backup, auditing and more.

New Features

  • Redesigned GUI: includes a NEW modernized home screen and a streamlined interface for unified, multi-tasking database management and development.
  • Vertical Query Results Mode: allows query results to be visualized as a column/value pair list, which is ideal for queries that produce few rows but many columns.
  • Cascaded DELETE Statement Generator: automatically performs the tedious task of creating DELETE statements for deleting a row referenced by foreign keys.
  • Improved Visual Entity-Relationship Model Synchronization: with live schemas, making the integrated database modeling tool even more useful for managing schemas.
  • 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.
  • NEW Table Data Search: enables a text search on any number of tables and schemas for rows matching a given pattern.
  • IMPROVED Server Status: provides a quick summary of server status and configuration.
  • Wizard Based Migration Support: for Microsoft SQL Server, Sybase Adaptive Server Enterprise (ASE), PostgreSQL and now NEW additional support for Sybase SQL Anywhere and SQLite.
  • Community Driven Features: MySQL Workbench 6.0 addresses well over 200 ideas and requests from the community.
  • MySQL Workbench 6.0 Enterprise Edition also includes:
    • NEW MySQL Enterprise Backup GUI: now allows setup, run, schedule, and view backups while in progress, as well as automating restores.
    • NEW MySQL Audit Log Inspector: allows users to browse and analyze audit data generated via MySQL Enterprise Audit. With powerful filtering and search capabilities users will be able to more easily assess the audit log content generated via MySQL Enterprise Audit.

Download

Platforms supported by MySQL Workbench include: Windows, Mac OS X 10.6+, Oracle Linux 6, RH 6, Fedora 18, Ubuntu 12.04 and Ubuntu 13.04

MySQL Workbench Community Edition is available free of charge under the GPL and is available for download

  • For Windows - as part of the MySQL Installer for Windows here;
  • For Mac OS X and Linux here.

MySQL Workbench Enterprise Edition which includes DBDoc as well as support for MySQL Enterprise Backup and Audit is available from My Oracle Support today or from Oracle Software Delivery Cloud for trial later.

Summary

MySQL Workbench 6.0 is the best release to date, with more capabilities and enhanced ease of use.

You can review the MySQL Workbench 6.0 documentation, and also ask questions to the development team and community via our the MySQL Workbench forum. We addressed over 200 ideas and requests from our community in this release. To those folks as well as all the Workbench 6.0 beta testers, a BIG thanks goes out to you.

If you’ve been using MySQL Workbench for some time, we hope you like the changes and improvements. If you’re new to MySQL Workbench, we look forward to working with you to continue evolving MySQL Workbench. As always please send us your ideas and feedback.

Get Started on the World's Most Trusted Open Source Database

Want to get started on the world's most trusted and depended-on open source database? Sign up for the MySQL for Beginners training course today.

In this 4-day, instructor-led course you will develop an understanding of relational databases and how to design a robust and efficient database. You will harness that power by learning SQL and use it to build databases, populate them with data and query that data through extensive hands-on practices.

You can take this live class as a:

  • Live Virtual Event: Take this class from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to take this class. Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

 Brussels, Belgium

 9 September 2013

 English

 London, England

 4 November 2013

 English

 Berlin, Germany

 9 December 2013

 German

 Stuttgart, Germany

 28 October 2013

 German

 Milan, Italy

 23 September 2013

 Italian

 Rome, Italy

 4 November 2013

 Italian

 Riga, Latvia

 26 August 2013

 Latvian

 Utrecht, Netherlands

 9 September 2013

 Dutch

 Warsaw, Poland

 1 October 2013

 Polish

 Barcelona, Spain

 21 October 2013

 Spanish

Madrid, Spain 

 21 October 2013

 Spanish

Petaling Jaya, Malaysia 

 17 September 2013

 English

Nairobi, Kenya 

 9 September 2013

 English

Mexico City, Mexico 

 14 October 2013

 Spanish

Sao Paolo, Brazil 

 7 October 2013

 Brazilian Portugese

To register for this course, to see the full course description or to learn more about the authentic MySQL curriculum, go to http://oracle.com/education/mysql.

About

Get the latest updates on products, technology, news, events, webcasts, customers and more.

Twitter


Facebook

Search

Archives
« August 2013 »
SunMonTueWedThuFriSat
    
1
3
4
6
8
9
10
11
14
15
16
17
18
21
23
24
25
26
30
31
       
Today