dbForge Studio (Edge) Reviews and Ratings

Rating: 8 out of 10

Score

8 out of 10

Community insights

TrustRadius Insights for dbForge Studio (Edge) are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

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.

Reviews

15 Reviews

The Tool of Choice for DBAs and Developers

Rating: 10 out of 10

Incentivized

January 4, 2022

Use Cases and Deployment Scope

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.

Pros

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

Cons

[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).

Likelihood to Recommend

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.

Verified User

Engineer in Information Technology (1-10 employees)

Vetted Review

6 years of experience

A good workmate to develop on SQL server

Rating: 8 out of 10

Incentivized

December 30, 2021

Use Cases and Deployment Scope

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!

Pros

"Visual Query Builder"
"Database Synchronization"
"Data Import and Export Tools"
"Visual Database Editor"
"Data Editor with filtering, grouping, and sorting"

Cons

Visual Query Builder (for example support UNION in Visual Query Builder)
SQL jobs functionality (for example scheduling Backup of Database)
Support Linked Servers

Likelihood to Recommend

In my opinion, dbForge is very useful for DB developers, while it might be lacking for DB administrators

Verified User

Technician in Information Technology (51-200 employees)

Vetted Review

1 year of experience

Good experience with dbForge Studio for MySQL

Rating: 9 out of 10

Incentivized

September 13, 2021

Use Cases and Deployment Scope

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.

Pros

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

Cons

It has only 30 day trial periods
Some time suggestions of joint operations are not accurate
For students it should be free

Likelihood to Recommend

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.

Mantosh Kumar

Consultant in Professional Services at Capgemini (10,001+ employees)

Vetted Review

3 years of experience

Best MySQL management tool I've ever used

Rating: 9 out of 10

Incentivized

May 13, 2021

Use Cases and Deployment Scope

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.

Pros

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.

Cons

Bit pricy maybe
UI doesn't always save preferences.

Likelihood to Recommend

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.

Verified User

Engineer in Information Technology (1-10 employees)

Vetted Review

2 years of experience

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

Rating: 10 out of 10

Incentivized

March 19, 2021

Use Cases and Deployment Scope

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:

<ul><li>A detailed wizard to compare data between databases or tables.</li><li>Importing and exporting data in many formats from csv's to Excel, Word, and just about anything else. </li><li>Database tools to check Sessions and Security.</li><li>SQL Query completion and error analysis.</li><li>Creation of Views and other objects with visuals and wizards.</li><li>Reporting and other great visuals that we just have not gotten around to yet.</li></ul>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.

Likelihood to Recommend

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.

Bob Guzek

IT Manager in Information Technology at CM Group Holdings, Inc. (11-50 employees)

Vetted Review

2 years of experience

View profile

The best platform for managing SQL Server databases

Rating: 10 out of 10

Incentivized

January 14, 2021

Use Cases and Deployment Scope

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.

<div>The software has very well-implemented features including

</div><ul><li>Database documenter</li><li>Database schema comparison and database data comparison</li><li>Unit test</li><li>Code formatting</li><li>Source control</li><li>Database designer</li><li>Index manager</li><li>Data generator</li><li>Search</li><li>Monitor</li><li>Backup and restore</li><li>Debugger</li><li>Query profiler</li><li>IntelliSense</li></ul>

Pros

Visual query designer
Great SQL editor
Simple to create tables and associated columns

Cons

Make it easier to enlarge/zoom table view
Don't automatically add columns to "group by" in query designer
No multi-editing

Likelihood to Recommend

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.

George Stoyle

Senior Manager, Technology & Innovation at Rare (51-200 employees)

Vetted Review

5 years of experience

Quick Database Comparisons

Rating: 8 out of 10

Incentivized

February 13, 2020

Use Cases and Deployment Scope

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.

Pros

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

Cons

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

Likelihood to Recommend

<p>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.</p><p>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.</p>

Chris Oros

IT Analyst in Information Technology at Duquesne Light Co. (1001-5000 employees)

Vetted Review

1 year of experience

dbForge Data Compare is a great tool for managing and syncing databases in multiple environments

Rating: 10 out of 10

Incentivized

July 12, 2019

Use Cases and Deployment Scope

Our dev team uses dbForge Data Compare for MySQL to sync data between pre-prod environments, look for differences in data for troubleshooting, and generate update scripts to sync other environments. Data Compare's comparisons can be customized for different scenarios and saved for re-used and sharing among the team. It also allows you to sync different sets of data between environments.

Pros

Compare entire or subset of MySQL tables between databases
Configure comparison rules
Sync data between compared databases depending on differences
Save comparison rules for reuse and sharing
Break down differences between missing/new records, or different records
See differences highlighted per field
Execute sync immediately, or save as an SQL script file
Command-line tool that can be used to add comparisons to deploy scripts

Cons

Comparison can be very slow on large datasets.
Comparing records that are *different* is clunky, especially for tables with many fields.

Likelihood to Recommend

<div>Data Compare covers two main use cases for us:</div><div>1) Keep data in sync between our development, test, and staging environments. When a full database import isn't practical, we will use Data Compare to sync data for key tables. We use this for configuration tables as well as operational test data.</div><div>2) Troubleshoot prod issues. When we have trouble reproducing user issues, Data Compare helps us compare our test environment data vs prod environment data to identify problems.

</div>

Anthony Aziz

Senior Software Engineer in Engineering at Full Circle TMS (1-10 employees)

Vetted Review

3 years of experience

Refreshingly easy to use tool!

Rating: 8 out of 10

Incentivized

January 26, 2019

Use Cases and Deployment Scope

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!

Pros

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.

Cons

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.

Likelihood to Recommend

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.

Aaron Smith

Senior Software Developer in Information Technology at TimeTrak Systems, Inc. (11-50 employees)

Vetted Review

1 year of experience

View profile

Best SQL Server IDE for Really Effective Development

Rating: 8 out of 10

Incentivized

January 26, 2019

Use Cases and Deployment Scope

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

Pros

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!

Cons

Should be more compatible with SQL Management Studio. Integration would be good.
Sometimes crashes.

Likelihood to Recommend

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.

Jhonathan de Souza Soares

Professor in Information Technology at Universidade Estadual de Campinas (11-50 employees)

Vetted Review

3 years of experience

View profile

Loading Reviews List....

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

Rating: 10 out of 10

Incentivized

March 19, 2021

Use Cases and Deployment Scope

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.

Likelihood to Recommend

Bob Guzek

IT Manager in Information Technology at CM Group Holdings, Inc. (11-50 employees)

Vetted Review

2 years of experience

View profile