- Database Designing & Modeling
- SQL database Development
- MySQL Database Administration tools for server configuration, user administration, and much more
- Database Migration
To download MySQL workbench clich here
Installation of workbench is very easy. Just download the MySQL Workbench software file and save it in your desired folder and run the file and follow the step by step instructions.
In previous blog What is MySQL Database Server. How to download and install MySQL Server and Workbench at Windows, we also installed MySQL workbench with MySQL Database Server.
MySQL Workbench has provided an easy way for Database server administration, designing, development, and forward & reverse engineering of database.
Below snapshot is showing the workbench home page overview
SQL Visual Design:MySQL Workbench enables a DBA, developer, or data architect to visually database design, model and to generate the database and managed it. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.
Below snapshot is showing the workbench SQL Visual database design overview
SQL Database Development
MySQL Workbench provides the visual tools for creating, executing, and optimizing the SQL queries. The Database Connections Panel enables developers to easily manage database connections. The SQL Editor panel provides the reuse of SQL snippets, color syntax highlighting and execution SQL history. The Object Browser provides an instant access to schema s and objects of database.
Database Server Administration
Workbench provides an easily and visually administer MySQL environments and has gained better visibility of databases. DBA and developers can use the visual tools for configuring the servers, administering the users and viewing the database health.
MySQL Workbench is now providing a complete and easy to use solution for migrating of Microsoft SQL Server, Sybase ASE, PostreSQL, and other RDBMS tables, objects and data to MySQL database. DBAs and developers can easily convert existing applications to run on MySQL database server for both on Windows and other platforms. It is also support migrating from old versions of MySQL to the latest version.