dbForge Studio

dbForge Studio

About TrustRadius Scoring
Score 8.3 out of 100
dbForge Studio

Overview

Recent Reviews

Read all reviews

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of dbForge Studio, and make your voice heard!

Pricing

View all pricing

Standard

$179.95

On Premise

Professional

$299.95

On Premise

Enterprise

$399.95

On Premise

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.devart.com/dbforge/mysql/st…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is dbForge Studio?

dbForge Studio is provided by Devart and is a universal front-end client for database management, administration and development. Devart's GUI tool provides utilities to compare, synchronize, and back up databases (e.g. MySQL, Oracle, SQL Server, PostgreSQL, etc.) with scheduling, and includes the possibility to analyze and report MySQL tables data. For example, dbForge Studio for MySQL works with any MariaDB database servers, and supports all MariaDB objects types. This solution enables users to visually design database structures, execute SQL queries and scripts, and manage MariaDB users and privileges.

dbForge Studio Features

  • Supported: Data Comparison and Sync
  • Supported: Data Editor
  • Supported: Administration and Maintenance
  • Supported: Database Backup and Restore
  • Supported: Database Refactoring
  • Supported: Debugger
  • Supported: Exporting and Importing Data
  • Supported: Object Editors
  • Supported: Query Builder
  • Supported: Data generator
  • Supported: Documenter
  • Supported: Copy database

dbForge Studio Screenshots

Screenshot of Code CompletionScreenshot of Schema CompareScreenshot of Database DiagramScreenshot of Data Export

dbForge Studio Videos

dbForge Studio for MySQL is a GUI tool for MySQL and MariaDB for database administration, management, and development. This video shows the key features of dbForge Studio for MySQL.
A tutorial for MySQL beginners. Learn what is relational database, and why people love MySQL.
When launching dbForge Studio, the first thing seen is its Start Page. For convenience, all the key functions of the Studio have been grouped into 6 tabs on the Start Page.

dbForge Studio Competitors

dbForge Studio Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationNo
Supported LanguagesEnglish

Comparisons

View all alternatives

Reviews and Ratings

 (39)

Ratings

Reviews

(1-14 of 14)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
Review Source
The well-known features of [dbForge Studio for SQL Server] not only sell [itself] but serve [to] make a real difference in small shops as the tool is all-encompassing. [When using dbForge Studio for SQL Server,] Teams, such as ours, don't have to acquire additional tools, be it schema comparison and deployment, code completion during coding projects, highly intelligent IntelliSense when it comes to object name lookup, aliasing, [or] code completions/suggestion, and this is just scratching the surface.
  • Schema compare and synchronization
  • Database documentation
  • Database performance analysis [and] optimization
  • On the fly code completion and object identification
  • Second to none object export mechanism and supported-formats
  • [The] installation error I've already reported (ABARTN).xml [could use some improvement]. This has to do with Windows Defender (the default Windows anti-virus) not allowing the installation on the default installation directory of dbForge Studio [for SQL Server], thus the error. [With] the workaround, [I] was to disable the anti-virus for the duration of the installation, then turn it back on when the installation [was] been completed.
  • [I would like to see] better defined licensing models for larger teams (seated vs. name licenses).
No tool on the market is equal to it - be it in its intelligent design, ease of use, ease of integration, multi-platform support, highly engineered features, and much more.
Score 8 out of 10
Vetted Review
Verified User
Review Source
I use dbForge Studio Professional to develop business applications that use databases hosted on MS SQL server. The features I like the most are: The "Visual Database Editor" function, which is very useful for visually "drawing" even complex queries. I chose dbForge Studio because, compared to other products with a visual editor, it is certainly the most advanced. All "Database Synchronization" functions. With the "Compare and Synchronize Schemas" I can synchronize the schema of the development database, where I create the changes, with that of the production database. The changes can be very granular such as on the single table. With the "Data comparison tool" I can instead see the differences in the data present between the development and production DB. Another feature that I really appreciate is the ease of entering data directly into the table and exporting them to external files (for example in Excel format)Technical support is commendable: When I wasn't even a customer yet, I reported a bug in the Visual Editor and the Support Team fixed it in record time. Another thing I appreciate about DbStudio is the fact that you can publicly ask for the implementation of new features and, if they are also voted on by other users, in some cases they are implemented. I am very satisfied with this product!
  • "Visual Query Builder"
  • "Database Synchronization"
  • "Data Import and Export Tools"
  • "Visual Database Editor"
  • "Data Editor with filtering, grouping, and sorting"
  • Visual Query Builder (for example support UNION in Visual Query Builder)
  • SQL jobs functionality (for example scheduling Backup of Database)
  • Support Linked Servers
In my opinion, dbForge is very useful for DB developers, while it might be lacking for DB administrators
Score 9 out of 10
Vetted Review
Verified User
Review Source
I am using dbForge Studio for MySQL in my current project, which is based on the agriculture domain. Currently, many other teams are using this product in my organization. It has many features that help us improve productivity like code completion and easy debug, which as a developer is very important. One big feature of dbForge Studio is that we can take backup of the whole DB and whenever needed we can restore it. Database Administrator is also important for any organization.
  • Code Completion
  • Its support run time query, which we can automate
  • It gives suggestions for joint operations
  • Easy to debug
  • We can see physical view models of the database
  • Easy to take backup and restore
  • It has only 30 day trial periods
  • Some time suggestions of joint operations are not accurate
  • For students it should be free
In my experience, dbForge Studio has one important feature for security, which is Database administration. It helps us to protect the database from a new user or someone who doesn't have enough experience to handle it. The debugging feature is also very useful for developers. It has a one-time subscription that helps organizations. Auto-completion and its code suggestion save development time. We can physically see data models and their relationships. We can take a backup of the existing database and either reuse or restore it.
Score 9 out of 10
Vetted Review
Verified User
Review Source
This is actually the best MySQL database management tool I've ever used. It's intuitive, it works over an SSH connection, it has a 'gibberish generator' to insert test data, it has a nice look and feel, it can automate repetitive tasks, etc. phpMyAdmin is great, but this is even better for medium to large scale projects.
  • Generates random data to test databases.
  • Copies data, but also compares database schemes.
  • Nice look and feel.
  • Responsive.
  • Easy to use.
  • Lots of features that don't clutter the screen.
  • Bit pricy maybe
  • UI doesn't always save preferences.
We're using this tool to do a scrum approach on a health care project. Managing the database schema is easy as drag and drop. The documentation almost generates itself now. I'm especially fond of schema comparison and synchronization. I can now easily upgrade the production database from the schema in acceptance.
Bob Guzek | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • 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.
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use various databases--SQL Server being one--and we use dbForge clients to access them all. dbForge Studio for SQL Server is significantly easier to use than SQL Management Studio and has additional functionality that allows me to be a lot more productive.

The software has very well-implemented features including
  • Database documenter
  • Database schema comparison and database data comparison
  • Unit test
  • Code formatting
  • Source control
  • Database designer
  • Index manager
  • Data generator
  • Search
  • Monitor
  • Backup and restore
  • Debugger
  • Query profiler
  • IntelliSense
  • Visual query designer
  • Great SQL editor
  • Simple to create tables and associated columns
  • Make it easier to enlarge/zoom table view
  • Don't automatically add columns to "group by" in query designer
  • No multi-editing
This software is perfect for general management of SQL Server databases and includes a powerful and intuitive GUI for SQL development--it is much more user-friendly than SQL Management Studio, expanding upon this product with many missing features. The query builder/designer is superb and database scripts are very easy to generate.
Score 8 out of 10
Vetted Review
Verified User
Review Source
As part of an Oracle Utilities Suite upgrade implementation, dbForge Studio is being used to compare schemas between our current production environments and test upgraded environments. This tool has been essential in identifying DDL, index, partitioning, and PK and constraint errors. Because of our ability to quickly compare schema details between environments, we are able to quickly respond to Oracle SRs to ask about discrepancies we see between our base version installs and their product documentation. Identification of missing columns, columns with incorrect data types and character lengths, and missing tables have been key to keeping the infrastructure and data conversion side of our project on track.
  • Quick, high-level comparison of thousands of tables and their details
  • Intuitive identification of findings, such as discrepancies, inconsistencies, things that are equal, and source/target environment changes
  • The ability to parameterize searches more would be advantageous. For example, being able to specify to only look for certain columns, certain data type changes, etc.
  • The output reports from dbForge are very plain and could contain more detail, and perhaps be structured more like a pivot table form Excel

Whenever a user or DBA wants to compare schematics between two environments, dbForge is extremely helpful. This is useful during version or framework upgrades, a database upgrade, patch implementations, service package implementations, or any time to environments would be different.

The time it would take to write and execute queries, and then compare is exponentially longer than it takes with dbForge, where this is done and you have an application that allows you to quickly identify incongruities.

Although experience here is limited, as only one question has been asked and answered promptly, the registration and licensing process was very smooth and professional. There are forums online that discuss dbForge issues, as well as a Facts and Questions section on dbForge's website, so product support does seem to exist if needed.
Aaron Smith | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We've been migrating our applications over to PostgreSQL from Microsoft's SQL Server. We've been on a mission to find a good replacement for SQL Management Studio that everyone uses, not only for development, but also just generalized querying/editing of data. We've tried quite a few tools and when it comes to data querying and editing, we landed on dbForge Studio for PostgreSQL. We started out using just the free version, which at this point in time only has a few drawbacks compared to the paid version. Eventually, Devart plans to have more available in the paid version, but what they have now was enough for us to make the decision to purchase it.

They do not currently have the ability to graphically design or edit table/database schemas, which makes this tool a no-go for most development tasks (unless you are just writing functions/stored procs, and then the intellisense is very handy). However, the grouping and sorting of data right through the data grids is extremely useful. Grouping is also a snap by a simple right-click on any column. You can even edit data from a query instead of having to edit all the data in the table!
  • Intellisense is rock solid.
  • Sorting, filtering, and grouping are super easy by just using the grid columns. No having to write queries!
  • UI is super intuitive.
  • There is a master-child detail designer where you drop tables into the designer, link up their relationships (whether there are foreign keys or not), and then you can view the linked data.
  • No table/database designers (yet). They have said it's coming.
  • No way to create scripts to create the database/tables that other tools have. This makes it difficult for developers to use to generate DDL scripts.
  • Data export does an individual insert per row of data, which is a little inefficient. Other tools will do a single insert for a configurable amount of rows per insert statement.
This is completely dependent on job function. If you need to just view/edit data, then this tool is hands down the most intuitive and easy to use for that purpose. Our support team will greatly benefit from the ease of use for sorting, filtering, and viewing data. However, for a development role it would be better to select a different tool unless, of course, that developer was trying to find data issues or see what the data looks like after operations have run.
Jhonathan de Souza Soares | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
dbForge Studio for SQL Server is a powerful IDE for SQL Server management and development in my company. SQL developers and DBAs uses the GUI tool to speed up almost any database experience, such as designing databases, writing SQL code, and generating meaningful test data. We use the dbForge Studio for SQL Server to deploy queries across different environments. It's very helpful
  • It's easy to use. DBAs and developers can use the dbForge Studio for SQL Server and no complex tutorial is needed.
  • Queries builder in a visual designer is awesome. Very powerful.
  • Database scripts are easily generated. And it is fast!
  • Should be more compatible with SQL Management Studio. Integration would be good.
  • Sometimes crashes.
It's good for if you need to: Edit and run queries in a new SQL document. Build queries in a visual designer. Run a large script without loading it into memory. Track changes of the production database. Create unit tests using a tSQLt framework. Source control database changes. Create database objects in a visual editor. Generate database scripts.
It's not so good if you need to: Manage user permissions or debug queries.
Score 6 out of 10
Vetted Review
Verified User
Review Source
dbForge Studio for Oracle is used mostly by our DBAs for administrative tasks, writing queries, etc. It was much more stable than any of the other potential solutions that we tested. It also allows us to synchronize data and schema for test cases, or to merging customized environments back into our core product for additional customization. Our Human Resources department was also looking into using this to manage their data as well.
  • It allows for easy synchronization between Oracle databases and schemas.
  • Installation and configuration was a breeze, so it provided a quick return on investment.
  • It runs quite well on standard hardware.
  • There can be problems when attempting to run it over Linux.
  • There were some formatting issues when Windows 10 came out, but they were addressed.
  • The full version was a little bit more expensive than we were hoping.
It is a great tool for synchronizing databases and schemas, especially when you need to take customized software for a particular client and bring it back in-house for additional enhancement requests. It is well-suited for environments where the easy-to-use GUI can provide almost instantaneous results with little or no training. It it highly scalable and can be used in one department or enterprise-wide.
Score 8 out of 10
Vetted Review
Verified User
Review Source
I mainly use dbForge Studio for SQL Server for query management and query editing. It is not widely used in the organization. The software allows me to write SQL codes efficiently and it helps me monitor the running SQLs.
  • dbForge Studio has a clear user interface to monitor SQL server performance. It allows me to kill large or possible inefficient SQL quickly so it doesn't impact the server too much.
  • I find the SQL editor to be more friendly to use than the competitors, which seems generic. I can preview tables while writing codes.
  • Does not support NoSQL, not a huge deal breaker but could be useful to my application.
  • Some functions could be made more automated like drag and drop. Not a huge issue though.
dbForge Studio is well suited for any database environment that allows multiple users to run queries simultaneously. It is essential to monitor and track server performance so no one can impact or damage the current and scheduled jobs easily.
Mortada Abdul Roda | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
I work at a company (Bumbal.eu) where we provide medium sized and small companies with a cloud based transport management software. With our software they can communicate available time windows to their customers, automatically optimize their planning and communicate current planning to their customers. dbForge is used to design the database for the software and to update all the productions databases with the newest releases. through the sync tooling in dbForge it is very easy to identify differences between database schema's and to produce update sql's to sync the schemas.
  • Connection manager (we use it through ssh tunnels) works effortlessly.
  • Great sync tools for both database schemas and data.
  • Storing code snippets to be used when needed.
  • Nice code suggestions while typing queries.
  • Usually does very well with storing your session and opening all of your sql tabs when opening the apps next time.
  • Does very well when executing large sql files (without opening the files into the application that is).
  • Pretty good debugging help when a problem occurs in executing a query or a files with multiple queries.
  • We have about 10 different server connections open at the same time to manage database on each of those servers. Unfortunately this breaks the very useful typing-suggestions of dbForge, as it no longer seems to understand where to look for the right tables and columns. The query does execute correctly though.
  • I wish there was an easy way to store a standard configuration when doing a backup for databases. There is a couple of tables which we never backup, and every time I have to uncheck those tables manually before doing a backup.
  • The JSON viewer is great, but is also unfortunately lacking in a couple of ways:
  • 1- No folding/unfolding of blocks
  • 2- Depending on the position of the data cell in your screen, the JSON viewer window can be displayed at an uncomfortable position and size, without an option to correct this, making reading the data very hard
  • 3- The search and find function for data in cells is very contra-intuitive: when I open a cell t view it's data, I do not expect the search and find function to hop to other cells. This causes me to loose my current view and having to find and load the cell I was in all over again.
  • This only happens rarely, but when it happens it is very frustrating: the backup or restore function freezes somewhere in the middle of the process without any error or warning message. But as said, this only happens very rarely.
  • I wish I could execute a file on multiple databases at once. At the moment I have to manually select each of the database where I would like to perform an update on before executing the update SQL.
  • Selecting rows of data and copying them into a table (with an equal number of columns and appropriate column definitions) as an update for existing rows sometimes gives unreasonable errors.
  • When editing the structure of a table, it is not possible to copy multiple column definitions to another table, or even just select a couple of columns and dragging them into a different position for the same table.
  • I have seen some very nice database analytics windows in other mysql clients like Querious and even Workbench. I really miss better statistics about running mysql servers + insight into currently running (slow) queries. I know this all available info, so it is unfortunate that I have to write queries and dig into the server myself to find this kind of info.
  • The look and feel really could be improved into a more modern and minimalistic application. Once again, look at Querious for inspiration.
In my experience dbForge is easily better than most of other db clients on Windows OS. I don't use all of it's functionalities, but the once I need and use are usually pretty stable and straightforward. There is however still a lot to improve in my opinion: the interface could use a more modern look and feel, I really miss the server stats and running queries info, batch executions on multiple databases would be awesome and if the typing predictions would be less buggy for users like us who have multiple server connections running at once, it would make work a little bit easier and faster.
Carlos Eduardo | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
I used dbForge Studio for MySQL in the IT department to support the development of the all systems used across the whole organization. Before dbForge Studio for MySQL the database administration was completely a mess, since I was the only database administrator along with 90 developers/programmers. dbForge Studio for MySQL came to address all the organization and to optimize our workflow.
  • dbForge Studio for MySQL worked perfectly well for a database administrator. The UI is very friendly and I was able to improve all tasks regarding my job, manage user privileges, table maintenance, server sessions etc.
  • The query development really improved with dbForge Studio for MySQL. All of the developer team had a much easier way to develop all the queries that were used inside the systems. The Visual Query Builder improved the performance and quality of the queries made by the developers and programmers.
  • The database designer brought to us a totally different vision of the database model. Before dbForge Studio for MySQL the database model was completely lost and corrupted. With dbForge Studio for MySQL we were able to put all objects together in a organized way. All of the IT department members knew where each table was connected to, and everybody was able to access the model before starting the development, reducing the inconsistencies of the company systems, and as a consequence we reduced the costs of development.
  • The development team reported that MySQL Debugger was a little hard to use. Some times when the process and consequently the code were not very simple, MySQL Debugger did not work well.
dbForge Studio for MySQL is perfectly suited to companies that run MySQL. Since it is a complete solution, both database administrators and developers can improve workflows with dbForge Studio for MySQL. For the development of the system queries and managing the model, or for backing up/restoring and synchronizing different databases, dbForge Studio for MySQL is the right tool to improve business.
Kevin Withers | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
I created a website and online store for my client - a company that restores vintage mustangs and sells parts. Occasionally my client will send me a spreadsheet containing updated parts prices. Because the company (Bigcommerce) that hosts the online store uses a MySQL database, and because I'm not particularly fond of using the command prompt to do database work, I wanted a tool to make my job easier. dbForge Studio does just that. The user interface is well thought out, and better organized and easier to use than Microsoft SQL Server. It's a real pleasure to work with and I actually look forward to getting price updates and other database work from my client so I can fire up dbForge Studio and use it.
  • The user interface is well thought out and well organized, and that makes dbForge Studio for MySQL a pleasure to use.
  • dbForge Studio for MySQL is exceedingly stable - I've never had a problem with it crashing or locking up; nor have I come across any bugs in it.
  • It's easy to make backups in dbForge Studio for MySQL, which encourages frequent backing up of schema and other important data.
  • I use dbForge Studio for MySQL in a limited environment - an online store hosted by Bigcommerce - so I don't see anything that cries out for improvement. It might be different if I was juggling multiple databases in an enterprise environment spread out over the Internet, but for what I need, dbForge Studio for MySQL does the job perfectly.
I can't say with certainty how well dbForge Studio for MySQL would perform in a complex environment, although based on my limited experience I suspect that it would do just fine. I use it execute some fairly uncomplicated SQL scripts on a downloaded database (1,283 records) and then check the results before uploading the database.