MySQL Workbench 6.0 - New Design and Many Enhancements
By Mike Frank on Aug 12, 2013
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.
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.
- 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.
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
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.
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.