About dbForge Studio for SQL Server

dbForge Studio for SQL Server is an on-premise database management solution designed for database developers, administrators and web developers. Key features include database conversion, data replication, access permissions, performance analysis and support for multiple programming languages.

dbForge Studio helps SQL developers and administrators to manage database experience related activities such as designing, writing a SQL code, comparing databases, generating test data and more. The solution also provides users with various reporting and analytics functionalities such as pivot tables, data comparison charts and a master-detail browser.

Additional features offered by the solution include index manager, table designer, query profiler, data editor a...


Read More

Supported Operating System(s):

Windows 7, Windows Vista, Windows XP, Mac OS, Linux, HP-UX, AIX, Solaris, Unix, IBM OS/400, Windows 2000, Windows 8, Windows 10

31 Reviews of dbForge Studio for SQL Server

Average User Ratings

Overall

4.55 / 5 stars

Ease-of-use

4.5

Value for money

4.5

Customer support

4.0

Functionality

4.5

Ratings Snapshot

5 stars

(19)

19

4 stars

(10)

10

3 stars

(2)

2

2 stars

(0)

0

1 stars

(0)

0

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 31 results

July 2020

Scott from SunPath

Verified Reviewer

Company Size: 11-50 employees

Industry: Information Technology and Services

Time Used: Less than 6 months

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Functionality

5.0

July 2020

Great SSMS replacement for MySQL newbies

So, for the record I'm an MSSQL guy from way back, and SSMS is my friend. I've been using it forever, and I think it's perhaps one of the best free pieces of software on the planet given what you can do with it. I like MSSQL/SSMS so much, and I'm so stubborn, that I stupidly connect to MSSQL when I am doing PHP pages. I took on a new client recently, and they are a MySQL shop, so I had to find a tool where the learning curve wouldn't waste a lot of my time. I have used the MSSQL version of dbForge Studio in the past, so when I realized they offered a MySQL version, I decided to give it a try. For me, dbForge Studio for MySQL is easily the closest in terms of look and feel to SSMS. I was able to install, connect to the sandbox they gave me, and dive right in. I was a little embarrassed about my lack of MySQL skills, so in about 30 seconds dbForge Studio was able to copy my sandbox DB over to a local MySQL server I set up so that I could play around with it and learn the nuances of MySQL over MSSQL. I ended up liking MySQL/dbForge Studio so much that I'm going to use MySQL as my go-to database technology on my projects going forward. I love this software and it offers a great value over its competitors and a shortened learning curve for those of use who use SSMS.

Pros

I love being able to completely copy a database from one server to another with a few clicks, which makes it super quick to keep my dev environment in sync with the live database. The code completion feature is so much quicker than SSMS, I love that you can set the delay, and it saves me a lot of typing in addition to keeping the case consistent within my SQL. The Visual Studio Blue makes it feel like I'm working with my old friend SSMS. The ability to mark different databases with shapes and colors is a thoughtful feature and reduces the chances of accidentally making a change in live instead of dev. The data generation feature is nice as well, as you can generate a lot of test data quickly. Also, one of the best features is the automated code formatting command (CTRL-K, D), which takes my sloppy, ill-formated SQL and turns it into beautifully formatted SQL. You can also easily output data to all kinds of formats including Excel, Sheets, csv, xml, etc., and save templates so that you can quickly generate the same reports.

Cons

The "Edit View" feature is a little clunky--you cannot edit SQL directly in the SQL tab, and when you try to do it in the Query Text tab, it constantly throws errors as you type. Sometimes you just need to do a quick edit to a view and it's a bit frustrating to deal with. I found myself opening up a new SQL window, copying my code, pasting into the new tab, modifying and copying back to the Query Text tab. There has to be an easier way.

Reasons for Choosing dbForge Studio for SQL Server

dbForge Studio for MySQL is the closest to SQL Server Management Studio in terms of look, feel, and functionality. The other options were awkward and unintuitive for me to use.

April 2020

Jhonathan from Vórtx

Verified Reviewer

Company Size: 51-200 employees

Industry: Financial Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

April 2020

It is a necessary tool for professionals

Pros

Intellisense is fantastic. You considerably reduce the amount of words typed

Cons

For large and complex queries, hardware consumption is something that needs to be improved.

Reasons for Choosing dbForge Studio for SQL Server

I believe it is a product that delivers value even if it costs less.

April 2020

Chuck from Visible Technology Solutions

Company Size: 2-10 employees

Industry: Computer Software

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

1.0

Value for money

3.0

Customer support

1.0

Functionality

3.0

April 2020

We tried, it failed.

It was ok, but settings and config were not intuitive and had to contact support several times and they were not very helpful.

Pros

it has syncing and backup built in and it looked to be a better product.

Cons

it only ran on windows, alot of our devs use macOS.

Reasons for Choosing dbForge Studio for SQL Server

I ended up going back to navicat.

April 2020

Dinand from Sommite Information Systems

Verified Reviewer

Company Size: 2-10 employees

Industry: Computer Software

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

April 2020

Can't do without it

I'm using dbForge on a daily basis and to be frank, I can't do my job without it. When I'm on a server without it, I install at least the express edition because the way dbForge supports writing queries is unmatched.

Pros

It's a one stop tool for my database tasks

Cons

Sometimes it crashes when I accidentally press F10

Reasons for Choosing dbForge Studio for SQL Server

dbForge is completer, more robust and more affordable. But above all, dbForge is more intuitive

June 2020

Jon from Beck Business Solutions

Company Size: 1 employee

Industry: Computer Software

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Functionality

5.0

June 2020

One of the few tools I can't do without!

I love it. I've used everything from SQuirreL SQL Client (not bad, open source java) to SSMS to TOAD and this is far and away the best product I've used. It's not even close.

Pros

dbForge Studio is essential for my team as it saves time and money for all of our developers no matter how much experience they have with SQL, Database maintenance and development (DDL), function & view creation/modification, etc. For my novice developers, dbForge has great tools to allow the developers to visually create a query using an intuitive UI. Once they create the query, they can examine the SQL dbForge creates to better understand how to write SQL using industry Best Practices. For experts, dbForge saves time (and typos) by giving us the ability to type a few characters instead of fully typing out the entire fiend name (for example typing 'usqd' instead of UserSurveyQueryData). It also has great tools for exporting so I can write and reuse an export query to dump data to pretty much any format (usually Excel 2007+) with consistent formatting. I also perform complex options like comparing the development and test databases to see not only structural differences (DDL) but even data differences upon demand. Once I've gone through and set the rules for SQL formatting, I can share them with the team and all of our SQL is consistently named and formatted.

Cons

We are restricted to installing on one machine. All of my developers use more than one computer. I myself have three. It's just the nature of the business and it's a real hassle not to be able to install on as many machines as I, as a single developer, use daily.

Reasons for Choosing dbForge Studio for SQL Server

Functionality. This product saves me time both in creating/updating DDL & functions and in catching typos/errors before they make it into testing.