Try our new research platform with insights from 80,000+ expert users

Devart dbForge Studio for SQL Server vs Oracle SQL Developer comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Devart dbForge Studio for S...
Ranking in IDE
11th
Average Rating
9.0
Number of Reviews
3
Ranking in other categories
No ranking in other categories
Oracle SQL Developer
Ranking in IDE
5th
Average Rating
8.6
Number of Reviews
30
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2024, in the IDE category, the mindshare of Devart dbForge Studio for SQL Server is 0.9%, down from 2.5% compared to the previous year. The mindshare of Oracle SQL Developer is 4.3%, down from 6.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
IDE
 

Featured Reviews

Lucas Dreyer - PeerSpot reviewer
A stable, scalable solution with excellent administration
The initial setup is straightforward. It's quite easy to create databases, administrate databases, and set up a backup. It's quite easy to install and to manage. Deployment can take up to three hours if you are installing the full SQL server. Setting up just the database is a couple of minutes. I haven't set up a full backup, or any of that myself. I've set up backups to local disks, however, and that's quite easy to do. Setting up jobs, or maintenance jobs that are running statistics on variables, shrinking, translating locked files, etc., only take a few minutes to set up. A full configuration would take two hours maximum.
Theodoros Loizou - PeerSpot reviewer
Useful features, simple implementation, and scalable
For first-time users of Oracle SQL Developer, it's going to be a bit difficult, but they can find their way around over time. I rate Oracle SQL Developer a nine out of ten. I didn't face any other issues other than it being a bit slow when you have a lot of work to do.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"I like the ease of use and quick data usage."
"It's quite easy to install and use from a local machine or laptop, as well as on a server."
"You do not have to install it, just dump it on the OS, then use it."
"Using execution plan, I am able to do lots of query tuning."
"The most valuable features of Oracle SQL Developer that I use. However, I do not use all of them"
"You can install it on every platform. It just works. The other thing is that it's free. And Oracle is committed to the development of the tool, so it has been improving."
"I like it because it's very similar in output to SQL *Plus, and it has many convenience features that make it easier to read the data and use the basic reporting features it provides."
"It's easy to deploy, I can copy it onto the system and run it without having to install it and this makes it a very good solution for quick use."
"I have a lot of flexibility with it."
"Ability to analyze performance, using Explain Plan statement."
 

Cons

"The only issue that I have is that it depends on hardware resources, it takes a lot, that is the only set back with the solution."
"The lock files and login are two features we've had issues with. As far as I can see, there's no way to switch off the login in SQL Servers. If there could be a way to switch off the login, for transactions, or in operations, or tables, that'd be great."
"If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager."
"Oracle SQL Developer could improve the speed, it is a bit slow."
"Scalability has room for improvement. Often if you have to do a heavy load of queries or are getting large result sets you have to be careful not to overload the Java virtual machine that's running."
"I think it would be great to have an overview over the sessions it opens so that we could easily see and control which connections to the database we want to keep open, which ones are hanging; and it would be great to make them independent from each other."
"There is room for improvement in the Real Time SQL Monitoring."
"There are occasional runtime issues that are easily worked around, especially on a Windows deployment."
"I would like it to support background processes better."
"The stability depends on what version you're using. There are more successful versions and are less successful versions. For example, 17.3 is less successful. There were many bugs. Now, we are trying to pull all the developers to upgrade to 17.4."
 

Pricing and Cost Advice

"Because it's 2012 version, it's a one-off enterprise license that we have never had to upgrade."
"It's a free tool."
"It is basically free."
"It's a no-cost license and it offers outstanding functionality on that basis."
"It has the advantage that it's free. The next best competitor would cost several thousand dollars."
report
Use our free recommendation engine to learn which IDE solutions are best for your needs.
824,053 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
23%
Government
15%
Computer Software Company
10%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Learn More

 

Overview

 

Sample Customers

Boeing, Sony, Honda, Oracle, BMW, Samsung
Prinova
Find out what your peers are saying about Devart dbForge Studio for SQL Server vs. Oracle SQL Developer and other solutions. Updated: December 2024.
824,053 professionals have used our research since 2012.