dbForge Studio provides lots of features at a competitive price

Reviewed on 16/06/2015
Rudy S.
Founder
Reviewer Source 
5/5
Overall
4 / 5
Ease of Use
Features & Functionality
4 / 5
Customer Support
Value for Money

Comments: Devart (formerly CoreLabs) has been expanding from their roots in the database driver business (I've used their MySQL .NET data provider for years) into providing a complete suite of database management tools.
dbForge Studio for MySQL Standard is their mid-tier product for MySQL management (also available for SQL Server and Oracle). The standard edition includes all the basic features you'd expect in a DB management tool like a good SQL editor with syntax highlighting and code completion, SQL formatting, a query profiler, backup/restore as well as data import/export. But it also includes some features you might not expect.
For the less experienced, there's a powerful visual query editor (even supports sub queries). I prefer to write my queries by hand--but it's a feature that might be important to some. There's a visual design tool that lets you build ERD diagrams. It's not as capable as TOAD, but it's great to have it included without a separate purchase.
The interface is consistent between their tools , so once you learn it, you know it. A split pane view lets you see both the SQL and the GUI view of the object at once. Wizards are used for most of the task based functionality (like backup or schema comparison).
I mostly use MariaDB rather than MySQL now and it supports MariaDB, Sphinx and Percona. They list support for MySQL 5.6 and 5.7 but I've used it with 5.5 as well and haven't had problems. It can also manage remote databases. I use SSH tunneling offsite (there is, of course, some performance cost).
To me, the real value comes in the Professional edition. Here you get all the standard edition features plus:
-- Database refactoring: this makes things like renaming fields MUCH easier as it correctly propagates changes to related fields, indexes, etc..
-- Schema and Data Comparison and Sync is a big one for me. I have a product that customers frequently want customized and merging their customization back into our core product is a frequent need.
--Command line support for lots of things like backup/restore, import/export, schema sync, etc...
--Pivot tables and reporting
--and more!
I like EMS, Redgate, TOAD too, but when you compare everything in dbForge, you are getting comparable tools at a very competitive price. They have 30-day trials and a basic freeware version too.
Devart DbForge Studio is a great value for SQL developers or administrators.

dbForge assisting in data auditing

Reviewed on 22/03/2019
Jeffrey M.
Software Security Analysts
Insurance, 5,001-10,000 Employees
Used the Software for: 1+ year
Reviewer Source 
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
Customer Support
5 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Pros: This product is easy to use to connect to Oracle dbs which we have running. The trial versions are complete enough to be able to complete coding tasks and monitoring. The intelliisense built in makes working with oracle a bit more easy with less resource intensive operations. You can also use the built in 'unit testing' modules to create and run tests efficiently. All settings and previous worked on files are automatically saved.

Cons: Not many cons a bout using the software. Integration with current software suite is fast. Hoping to get the full suite of dbForge through company.

Great alternative for SQL Management Studio

Reviewed on 03/10/2018
Patrick E.
Data Analyst
Hospital & Health Care, 51-200 Employees
Used the Software for: 6-12 months
Reviewer Source 
4/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: I'm using it as a daily driver for querying and extracting report from the database

Pros: The overall functionality and ease of use

Cons: just some missing features that are available from other software

dbforge review

Reviewed on 04/10/2016
Joe F.
Data Architect
Financial Services, 1,001-5,000 Employees
Reviewer Source 
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: Overall it is great tool. Some quirks with Windows 10 with the UI but overall a great tool forr SQL development

Pros: Simple and easy to use interface. Great tools for the DBA

Cons: Ui has some issues with Windows 10, text gets out of alignment

Great SQL GUI

Reviewed on 04/10/2016
David M.
Reviewer Source 
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: This has a ton of features and very friendly. We never have any problems and support is very responsive.