Recently, Oracle released the latest version of MySQL Workbench 6.0, including the Community version and the enterprise version, to improve the development and management of MySQL databases.
MySQL Workbench is a unified visualization tool designed for database architects, developers, and DBAs. MySQL Workbench provides data modeling tools, SQL development tools, and comprehensive management tools (including server configuration, user management, and backup) that can be used on Windows, Linux, and Mac OS.
Monica Kumar, senior director of Oracle product marketing, told reporters that the biggest improvement of MySQL Workbench 6.0 lies in the graphical user interface (GUI) and workflow, it also provides developers and DBAs with more modern and streamlined tools for designing, developing, and managing databases.
MySQL Workbench details: click here
MySQL Workbench: click here
Related reading:
MySQL Workbench Chinese tutorial
MySQL Workbench "Error Code: 1175" SOLUTION
The Community version is open-source and can be freely used with the GPL license, including the redesigned graphical user interface (GUI. The graphic user interface (GUI) is designed to provide a smoother interface for database development and management.
MySQL Workbench 6.0 community edition includes wizard-based migration support, which can be migrated from other databases such as PostgreSQL, Microsoft SQL Server, Sybase SQL Anywhere, and SQLite to MySQL.
In addition, MySQL Workbench 6.0 includes the new Schema Inspector and table data search functions, providing better server status and configuration information to help database developers develop and manage MySQL.
Monica Kumar said that MySQL Workbench Enterprise Edition provides the following additional features compared with the Community edition:
· Architecture and Model Verification
· DBDoc
· Graphical user interface (GUI) for MySQL Enterprise Backup)
· MySQL Enterprise audit graphical user interface (GUI)
Both MySQL Workbench 6.0 community edition and Enterprise Edition can be applied to MySQL commercial edition and open-source edition, as well as potential branches of MySQL MariaDB. Monica Kumar said that Oracle tested MySQL Workbench on all versions of MySQL and it should be compatible with the MySQL branch.
Functions of MySQL Workbench
Design
MySQL Workbench allows DBAs, developers, or data architects to visually design, model, generate, and manage databases. It has all the functions required by data modeling tools to create complex ER models and supports forward and reverse engineering, it also provides some key features to perform change management and documentation tasks that usually require a lot of time and work.
Development
MySQL Workbench provides some visual tools to create, execute, and optimize SQL queries. SQL Editor supports syntax highlighting, automatic filling, SQL code segment reuse, and SQL Execution history. Developers can use the Database Connections Panel to easily manage Database Connections. You can use Object Browser to instantly access database modes and objects.
Management
MySQL Workbench provides a visual console that allows you to easily manage the MySQL environment and learn more about the database running status. Developers and DBAs can use these visualization tools to configure servers, manage users, perform backup and recovery, check audit data, and view database health.
New: database migration
MySQL Workbench provides a comprehensive and easy-to-use solution for migrating Microsoft SQL Server, Sybase ASE, PostreSQL, and other RDBMS tables, objects, and data to MySQL. Developers and DBAs can easily and quickly convert existing applications so that they can run on Windows and MySQL on other platforms. It also supports migrating from an earlier MySQL version to the latest version.