Devart

dbForge Studio for SQL Server

4.5 / 5 2 reviews

Who Uses This Software?

Database developers, administrators; Web-developers


Average Ratings

2 Reviews
  • 4.5 / 5
    Overall
  • 4 / 5
    Ease of Use
  • 3.5 / 5
    Customer Service

Product Details

  • Starting Price
    $149.95/one-time/user
  • Free Version
    Yes
  • Free Trial
    Yes
  • Deployment
    Installed - Windows
  • Training
    Documentation
    Live Online
  • Support
    Online
    Business Hours

Vendor Details

  • Devart
  • www.devart.com
  • Founded 1997
  • Czech Republic

About dbForge Studio for SQL Server

dbForge Studio for SQL Server is an integrated environment for SQL Server development, management, administration, data reporting and analysis. SQL Manager tools allows easily to create, edit, copy, attach, detach, backup and restore databases from one server to another. These SQL tools help developers to manage databases, speed up routine tasks and make complex database changes.


dbForge Studio for SQL Server Features

  • Backup
  • Creation / Development
  • Data Migration
  • Data Replication
  • Data Search
  • Database Conversion
  • Monitoring
  • Performance Analysis
  • Queries
  • Relational Interface
  • Virtualization

dbForge Studio for SQL Server Reviews

dbforge review

Oct 04, 2016
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

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

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

dbForge Studio provides lots of features at a competitive price

Jun 16, 2015
5/5
Overall
4 / 5
Ease of Use
4 / 5
Customer Support

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.