Devart Blog

MySQL WorkBench Worthy Alternative – dbForge Studio for MySQL

Posted by on June 21st, 2013

Did you know that dbForge Studio for MySQL is a great alternative to MySQL Workbench? In case you have used MySQL Workbench in the past, or consider using it now, you might want to take a closer look at dbForge Studio for MySQL, to make sure you pick wisely the tool that will meet your requirements the best.

Every single year the software industry introduces new DBMSs which allow developers to achieve goals and objectives more efficiently. However, in order to benefit from all the features provided by the modern DBMS, you should define which one is more suitable for team’s needs.

Today we are going to draw a parallel between two similar products, that allow performing numerous tasks in MySQL environment. Both of them are specialized visual database design tools for MySQL databases. These products are MySQL Workbench 5.2.47, and it’s alternative — dbForge Studio for MySQL 6.0.

Feature Comparison

Since the products are similar to each other they mainly provide the same functionality, but there is a huge difference in the performance efficiency. So, let’s have a closer look at it.

Code Completion

One of the most convenient features, which allows boosting SQL code writing is an automatic code completion. MySQL Workbench exposes prompts in a single window with the keywords, tables, views, functions, and stored procedures.

MySQL Workbench Completion List

MySQL Workbench Completion List

In turn, dbForge Studio for MySQL provides more intelligent code completion mechanism by showing all the database objects. dbForge Studio for MySQL implements code parsing, and shows results based on the context. The results are filtered in the list, to avoid showing options that are not relevant or distracting. Besides, dbForge Studio for MySQL shows quick object’s info, and parameter information for stored procedures, automatically generates JOIN clauses, provides column picker feature that allows selecting multiple column suggestions from the list, and many others.

dbForge Studio for MySQL Completion List

dbForge Studio for MySQL Completion List

Code Snippets

Using code snippets significantly speeds up the code development process. Inside dbForge Studio for MySQL code completion feature contains snippets, thus you can select a required one while coding. You are welcome to add a new snippet, or to amend an existing one using a convenient editor.

dbForge Studio for MySQL Snippets Manager

dbForge Studio for MySQL Snippets Manager

Vast majority of dbForge snippets support parametrization. For instance, when you insert a code snippet in your code, replaceable parameters in the snippet are highlighted so that you can locate them more quickly.

dbForge Studio for MySQL Highlight Occurrences

dbForge Studio for MySQL Highlight Occurrences

Although MySQL Workbench provides many snippets, they do not support parametrization. In most cases using snippets is far from convenient in MySQL Workbench as they are not a part of the code completion feature, and a special command needs to be used to select a snippet.

MySQL Workbench Snippets Manager

MySQL Workbench Snippets Manager

Code Formatting

One of the important rules while designing databases is to keep the code clear and well formatted, this allows reducing expenses for further code development and maintaining. However, in most cases the deadlines and requirements of the business logic make impact to the code appearance. Unreadable code may lead to significant downtime while analyzing. To help you match the code with your personal preferences, dbForge Studio for MySQL provides auto formatting feature with an ability to fine-tune each SQL statement.

dbForge Studio for MySQL Code Formatter

dbForge Studio for MySQL Code Formatter

MySQL Workbench only allows to uppercase or lowercase a statement. It also provides a simple code formatting based on your own needs. This way not everyone’s taste can be satisfied.

Dependencies Search and EER Diagrams

While developing a database, a developer needs to bear in mind the dependencies which exist between tables. EER diagrams makes life easier and display all the dependencies between tables. Both products allows developers to create such diagrams.

MySQL Workbench Dependencies

MySQL Workbench Dependencies

dbForge Studio for MySQL Dependencies

dbForge Studio for MySQL Dependencies

However, it is not too convenient to look up the required dependency on the diagram each time you need it. That is why dbForge Studio allows viewing dependencies directly in the objects explorer.

dbForge Studio for MySQL Objects Explorer

dbForge Studio for MySQL Objects Explorer

Refactoring

A database schema modification is almost inevitable while refactoring a database. It is the most resource-consuming task, especially when a database is under Production. MySQL Workbench users have to change manually all the occurrences of an old table or column names while renaming database objects.

 dbForge Studio for MySQL users can use refactoring features to automate this process.

dbForge Studio for MySQL Refactoring

dbForge Studio for MySQL Refactoring

Summary

You are welcome to act as judges to evaluate one of the best MySQL Workbench alternatives — dbForge Studio for MySQL. You can download and try out the Professional version of dbForge Studio for MySQL for free during 30 days.
Give dbForge Studio for MySQL a try and you will use it for any task related to the MySQL DBMS.

3 Responses to “MySQL WorkBench Worthy Alternative – dbForge Studio for MySQL”

  1. Enow B. Mbi Says:

    Excellent article.You didn’t mention platform support – linux or windows or mac os
    I’m in support of the issue of code completion in WB – it’s horrible to say the least.

  2. Sandy Says:

    dbForge is a 1000% better then MySQL workbench and worth every penny. The interface and most other aspects are much better suited then the workbench and makes you job a lot easier. dbForge is worth a look at if you spend any amount of time working on MySQL.

    Sandy

  3. Bsienn Says:

    Though dbforge is is superior to mysql workbench, comparing a free tool with the commercial professional version is not fair at all. Compare workbench with the express version then the results will vary.

Leave a Reply