Posts tagged MySQL
MySQL Workbench
Mar 21st
MySQL Workbench was recently rewritten from scratch and is now available in both free and commercial versions. The free version is not feature-crippled, but the commercial version includes some plug-ins that help automate tasks so that they require less manual work. At the time of this writing, the new version of the MySQL Workbench tool is still in beta.
It’s super-easy to use and I’ll just copy its feature list:
- Cairo based diagramming canvas which allows output to different targets such as OpenGL, Win32, X11, Quartz, PostScript, PDF etc
- visual representation of tables, views, stored procedure/functions and foreign keys
- live database and SQL script file reverse-engineering
- database/model synchronization
- SQL script generation
- extensible architecture
- export as SQL CREATE script
- import DBDesigner4 models
- support for MySQL 5 features
- selectable notations for diagram
For me, it’s a very useful tool for importing an SQL script, visually modifying it, and exporting a working SQL script. It’s also a cinch to just create ER diagrams in 5 damn minutes that look decent and map out foreign key relationships.
I’ve used DBD4 in the past as well as Aqua Data Studio and this tool gets me more excited. If you design or work with MySQL databases, you should check it out (see screenshots). Right now it’s Windows-only but they plan on releasing Linux and OSX in June, 2008.
Overall, very nice work MySQL — this tool is light years ahead of its predecessors.
MySQL developer tools
Mar 19th
MySQL Query Browser
MySQL Query Browser is a database querying tool that combines the simplicity of a Web-browser-like interface with powerful features like multiple result sets on tab sheets, query history, storing query “bookmarks”, editing and comparing resultsets, SQL script debugging, and more.
MySQL Query Browser can be used for tasks such as running queries, creating tables and stored procedures, exporting data, and browsing database structures. It has integrated documentation on MySQL’s SQL commands and functions. It is most useful for those who develop and query MySQL databases.
[http://www.mysql.com/products/tools/]
MySQL Administrator
MySQL Administrator is a powerful visual administration console for MySQL, which allows the user to easily administer their MySQL environment, and gain better visibility of how their databases are operating. It is available with native GUI interfaces for Windows, Linux, and Mac OS X.
MySQL Administrator is focused on server administration and is therefore most useful for DBAs, not developers or analysts. It helps automate tasks such as creating backups, creating users and assigning privileges, and viewing server logs and status information. It includes some basic monitoring functionality, such as graphing status variables, but is not as flexible as the interactive monitoring tools presented later in this post. It also doesn’t record the statistics for later analysis, which many other monitoring tools are designed to do.
[http://www.mysql.com/products/tools/]
MySQL Migration Toolkin
MySQL Migration Toolkit is a software pack to convert any data source to MySQL and vice versa. It includes the following utilities:
- Access-to-MySQL – migrates MS Access database to MySQL server;
- DBF-to-MySQL – moves DBase (dbf) databases to MySQL server;
- Excel-to-MySQL – converts MS Excel spreadsheet into MySQL database;
- MSSQL-to-MySQL – migrates MS SQL database to MySQL server;
- MySQL-to-Access – converts MySQL database into MS Access format;
- MySQL-to-DBF – converts MySQL databases into DBase (dbf) format;
- MySQL-to-Excel – converts MySQL database into MS Excel spreadsheet;
- MySQL-to-MSSQL – migrates MySQL database to MS SQL server;
- MySQL-to-Oracle – migrates MySQL database to Oracle server;
- Oracle-to-MySQL – migrates Oracle database to MySQL server.