dbForge Studio for MySQL creates a nice warm hearth for database management and automation
March 19, 2021

dbForge Studio for MySQL creates a nice warm hearth for database management and automation

Bob Guzek | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with dbForge Studio for MySQL

dbForge Studio for MySQL is being used across the organization as the primary DBA and developer tool to interact with our MariaDB and MySQL databases. We have a small IT staff, so it's critical to have a tool that works well for many tasks as these databases run our ecommerce engine and manufacturing. These are they key functions that this tool performs every day:
  • A detailed wizard to compare data between databases or tables.
  • Importing and exporting data in many formats from csv's to Excel, Word, and just about anything else.
  • Database tools to check Sessions and Security.
  • SQL Query completion and error analysis.
  • Creation of Views and other objects with visuals and wizards.
  • Reporting and other great visuals that we just have not gotten around to yet.
It has served as the tool to get us from one database version to another and from one platform to another. It's very handy at creating and modifying stored procedures as its code completion and suggestions are right on. For our IT staff, it serves as a tool to speed up database tasks all in one place.

Pros

  • Import and Export wizards from and to many different sources with a lot of options and a very handy wizard. I am able to import data to tables that other import tools choke on. The wizard is able to export or import to 15 different options.
  • It can compare data between tables or databases, which is great as it is, but it also has a schema comparison tool. It makes an all around set of tools useful for upgrades or syncing up databases.
  • The create view/edit view tool makes that process as easy as dragging and dropping without losing functionality. You can drag from any tables, perform functions on any field, and visually see all of your joins, grouping, and other criteria both visually and in generated SQL.
  • The database explorer is really nice as it allows grouping, and coloring databases based the type of environment.
  • I could keep going, but I'll end with the command-line generation, which allows the creation of a snippet of script code that automates the tool. We have some repetitive tasks that are completely executed at the command-line via a script.

Cons

  • The import wizard is really good, but I would like to have a direct import from a SQL Statement.
  • The Create View or Modify View function generates the SQL, and you can edit the SQL directly. This is really handy, but directly editing the SQL sometimes produces errors in the view's logic. The conversion from SQL to the visual tool is not always clean.
  • In the database explorer, I like to keep all of my database connections all neat and orderly in there, which works great with color coding, but it would be a nice to have non-connection objects to create spacing and other organizational functions.
  • Positive impact on reducing need for additional staff and ability for staff to perform DBA tasks on their own. I would say approx. 20% savings.
  • Automation of critical tasks like various data exports/imports. ROI was greater there, nearly 70% since it eliminates entire tasks.
  • Positive impact on an objective to enabling remote management in one tool for our database management.
  • We wanted to make database management easier, and the tool makes it about 30% easier. The tasks still require specific knowledge, but it's a good start.
I would say that dbForge equals or beats most of the abilities of the other tools I evaluated at the time. dbForge had better support (Devart), and regular feature updates. dbForge has better tools for data comparison and import/export. The price tag is slightly higher, but renewals rates are pretty good. It's a quality tool that still is well worth the cost.

Do you think dbForge Studio (Edge) delivers good value for the price?

Yes

Are you happy with dbForge Studio (Edge)'s feature set?

Yes

Did dbForge Studio (Edge) live up to sales and marketing promises?

Yes

Did implementation of dbForge Studio (Edge) go as expected?

Yes

Would you buy dbForge Studio (Edge) again?

Yes

This tool is useful for small and large IT departments and associated data analysts that perform direct database functions such as DBA tasks or extracting/importing data. Non-technical staff members would not benefit from this tool as much as the functions are detailed and technical. However, automation engineers will find this tool very open for automation, and can generate the scripting code for any of its functions.

Comments

More Reviews of dbForge Studio (Edge)

  1. Home
  2. Database Management Systems
  3. dbForge Studio (Edge) Reviews
  4. User Review of dbForge Studio (Edge)