Skip to main content
TrustRadius
dbForge Studio (Edge)

dbForge Studio (Edge)

Overview

What is dbForge Studio (Edge)?

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…

Read more
Recent Reviews

TrustRadius Insights

dbForge Studio for MySQL has received praise from users and reviewers for its wide range of use cases and valuable features. Users have …
Continue reading
Read all reviews
Return to navigation

Pricing

View all pricing

Standard (subcription)

$9.95

On Premise
per month

Professional (subscription)

$19.95

On Premise
per month

Enterprise (subscription)

$29.95

On Premise
per month

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
Return to navigation

Product Details

What is dbForge Studio (Edge)?

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 Edge - multidatabase solution that covers an all-consuming range of tasks for various database systems.

dbForge Studio (Edge) Features

Database Development Features

  • Supported: Version control tools
  • Supported: Test data generation
  • Supported: Performance optimization tools
  • Supported: Schema maintenance
  • Supported: Database change management

Database Administration Features

  • Supported: User management
  • Supported: Database security
  • Supported: Database status reporting
  • Supported: Change management

Additional 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 (Edge) Screenshots

Screenshot of Code CompletionScreenshot of Schema CompareScreenshot of Database DiagramScreenshot of Data ExportScreenshot of Database design & developmentScreenshot of Visual query building

dbForge Studio (Edge) Technical Details

Deployment TypesOn-premise
Operating SystemsWindows, Linux, Mac
Mobile ApplicationNo
Supported LanguagesEnglish
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(51)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

dbForge Studio for MySQL has received praise from users and reviewers for its wide range of use cases and valuable features. Users have found it to be an essential tool for interacting with MariaDB and MySQL databases, particularly in comparing data between databases or tables. The software's ability to import and export data in various formats, such as CSV, Excel, and Word, has been commended for its convenience in working with different file types. Additionally, the database tools in dbForge Studio for MySQL have been highly appreciated for their session and security checks, enabling users to effectively monitor and maintain their databases' integrity.

The SQL query completion and error analysis feature has proven to be a valuable asset for developers, enhancing productivity by providing real-time suggestions and identifying errors. The creation of views and other objects with visuals and wizards simplifies the process of creating and modifying stored procedures. Users have praised dbForge Studio for MySQL's reporting and visualization capabilities, although some have not fully explored these features yet.

Furthermore, the software has been instrumental in facilitating database version upgrades and platform migrations, ensuring smooth transitions between database versions and platforms. Its code completion and suggestion functionalities have garnered commendation for their accuracy and effectiveness in expediting IT staff's database tasks. Notably, during an Oracle Utilities Suite upgrade implementation, users have found the tool crucial in identifying DDL, index, partitioning, PK, and constraint errors, allowing them to promptly address discrepancies.

In various industries like transport management software development and agriculture, dbForge Studio for MySQL has played a significant role in improving productivity through features like code completion, easy debugging, database design capabilities, query writing, generating meaningful test data, and more. The software has proven valuable across organizations in optimizing workflows and addressing database administration challenges.

For specific use cases like updating parts prices in a MySQL database for a company dealing with vintage Mustangs and selling parts, dbForge Studio for MySQL stands out with its user-friendly interface and efficient functionality. The ability to take backups of the entire database and restore them as needed has been widely appreciated by users.

Additionally, dbForge Studio for SQL Server has been lauded for its user-friendly experience compared to SQL Management Studio, empowering users to be more productive in SQL Server management and development tasks. Its features, including database documentation, schema and data comparison, unit testing, code formatting, source control, database design, index management, data generation, search, monitoring, backup and restore, debugging, query profiling, and IntelliSense have been well-implemented and eliminating the need for additional tools and providing benefits in schema comparison and deployment, code completion, intelligent IntelliSense, and code suggestions. Likewise, dbForge Studio for PostgreSQL has gained recognition as a suitable replacement for SQL Management Studio, particularly for data querying and editing tasks. Its well-organized user interface and useful features like grouping and sorting data directly in the data grids have been appreciated by users.

The versatility of dbForge Studio for MySQL extends to its usage in syncing data between pre-production environments, troubleshooting differences in data, and generating update scripts for syncing other environments with the help of dbForge Data Compare for MySQL. Users have found this tool valuable in maintaining consistency across various stages of software development.

Technical support for dbForge Studio products has received commendations, with prompt bug fixes reported even before becoming customers. Additionally, the ability for users to publicly request new features that are implemented if voted on by other users demonstrates a responsive approach to meeting user needs.

Across different domains such as query management and editing, designing databases, writing SQL code, monitoring running SQLs, administrative tasks, and data management for HR departments, dbForge Studio products have proven to be reliable and efficient tools. Users appreciate the intuitive interfaces, SSH connection capability, gibberish data generator, and automation of repetitive tasks in dbForge Studio for SQL Server.

In summary, dbForge Studio products have been valued by users as critical tools for interacting with databases like MariaDB, MySQL, SQL Server, and Oracle. The software offers a wide range of features including data comparison and synchronization, code completion and analysis, visualization capabilities, version control support, backup and restore functionality, database design tools, as well as excellent technical support. It addresses various needs across industries such as software development, database administration, query management, and more.

Useful Import and Export Wizards: Many users have found the Import and Export wizards in the tool to be very useful, with a lot of options and a handy wizard. Several reviewers appreciate the ability to import data to tables that other import tools struggle with.

Effective Data Comparison Tools: The tool's ability to compare data between tables or databases is highly praised by users. It has been described as great for identifying discrepancies, inconsistencies, and changes between source and target environments. Some users also value the schema comparison tool, which is useful for upgrades or syncing up databases.

Intuitive Create View/Edit View Tool: Users find the create view/edit view tool intuitive and easy to use. They appreciate being able to drag and drop from any table, perform functions on any field, and visually see all joins, grouping, and other criteria. This feature doesn't compromise functionality while making the process easy for users.

Inconsistent SQL conversion: Some users have mentioned that the conversion from SQL to the visual tool in dbForge Studio is not always clean, leading to inconsistencies and errors in the view's logic.

Limited customization of output reports: Several users have expressed dissatisfaction with the plain and minimalistic output reports generated by dbForge Studio. They believe that these reports lack detail and structure, suggesting that they could be improved with more comprehensive information and a pivot table-like format.

Lack of database analytics windows: A number of users have pointed out the absence of database analytics windows in dbForge Studio. They feel that this hampers their ability to gather insights into currently running queries and obtain better statistics about their MySQL servers.

Users commonly recommend dbForge Studio for MySQL for the following reasons:

  1. The software is highly praised for its professional support, reliability, and feature set. Users appreciate the level of assistance provided by the developers and find the software to be stable and trustworthy.
  2. Many users suggest trying out the trial version of dbForge Studio for MySQL before purchasing the licensed version. They mention that it doesn't take long to realize the need for the full version due to its comprehensive features and efficiency compared to other free tools.
  3. Transitioning from other database management tools, such as SQL Server Management Studio or MS Access, to dbForge Studio for MySQL is often recommended as a smooth process that allows users to start producing results immediately. They find the interface intuitive and emphasize the ease of use. It's important to note that these recommendations are based on user experiences and opinions, which may vary depending on individual needs and preferences.

Attribute Ratings

Reviews

(1-4 of 4)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
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.
  • Code completion and the highly capable IntelliSense
  • Schema comparison and synchronization
  • Database documentation (which is very valuable when consulting for clients [in a] highly regulated environment)
  • The depth and breadth of its features saved us money in purchasing additional tools.
  • [It is] way more efficient in the tasks we used this tool for.
dbForge [Studio for SQL Server] is far superior in its features, capabilities, ease [of] use, menu layout, and sophisticated design.
Score 8 out of 10
Vetted Review
Verified User
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
  • Visual Query Builder
  • Working with Data in Data Editor
  • Working with Search
  • Database Synchronization
  • Sometimes it is sufficient to copy only one table between the test DB and the production DB.
  • dbForge Studio allows you to synchronize it in a few simple steps and considerably reduces the execution time.
  • it is not the perfect tool but in my opinion, there is very little to reach perfection. In my opinion, it is 80%. Self
  • a couple of the most requested features by users were implemented would be great (100%).
Before choosing dbForge Studio I evaluated at least a dozen tools, especially on the Visual Query Builder function. For now, I have identified only one product that has a better Visual Query Builder than dbForge Studio. This other product also manages UNIONs, while dbStudio still doesn't do it visually. However, the better alternative product is enormously slower in operations and less feature-rich than DbForge Studio
Score 9 out of 10
Vetted Review
Verified User
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.
  • It helps us execute and create different types of queries
  • It supports runtime and debugging
  • We can automate database object queries
  • Database Administration is useful for security
  • It saves a lot of time for development because of its auto completion feature
  • Easy to understand because everything is visible with a simple UI
[dbForge Studio for MySQL is] easy to understand and use because it has a sample UI. We can visibly see database tables and their relationships. We can automate queries according to our use and give access according to their use. Not everyone can delete the table or modify it. Using this we can optimize query performance, which improves application smoothness. We can also easily debug and fix issues. Whenever required we can take backup of database restoration as well.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Schema comparison
  • Automation of documentation
  • Lets us feel lots safer about how we migrate from one database version to another.
NetBeans, Microsoft 365 (formerly Office 365), N-able RMM (formerly Solarwinds RMM)
Return to navigation