Compare Devart dbForge Studio for SQL Server vs. Oracle SQL Developer

Devart dbForge Studio for SQL Server is ranked 2nd in IDE with 2 reviews while Oracle SQL Developer is ranked 1st in IDE with 13 reviews. Devart dbForge Studio for SQL Server is rated 9.0, while Oracle SQL Developer is rated 8.4. The top reviewer of Devart dbForge Studio for SQL Server writes "A stable, scalable solution with excellent administration". On the other hand, the top reviewer of Oracle SQL Developer writes "It tightly integrates with other Oracle products and database features/options". Devart dbForge Studio for SQL Server is most compared with Oracle SQL Developer, Eclipse Luna and dbForge Studio for MySQL, whereas Oracle SQL Developer is most compared with Toad, Eclipse Luna and NetBeans.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Oracle, Devart, JetBrains and others in IDE. Updated: December 2019.
384,324 professionals have used our research since 2012.
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.

Read more »

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.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 have a lot of flexibility with it.The newer version has a lot of new features. It generates output and scripts for your Ultrix. It can generate JSON, XML, etc.You do not have to install it, just dump it on the OS, then use it.Ability to analyze performance, using Explain Plan statement.Using execution plan, I am able to do lots of query tuning.

Read more »

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.

Read more »

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.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.There is room for improvement in the Real Time SQL Monitoring.It's more stable sometimes and less stable other times. I have used it in Windows, Mac, and Linux. It's variable, it's not the same stability. I think that can be improved on.I would like it to support background processes better.If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager.The competing products have more features.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.

Read more »

Pricing and Cost Advice
Because it's 2012 version, it's a one-off enterprise license that we have never had to upgrade.

Read more »

It has the advantage that it's free. The next best competitor would cost several thousand dollars.It is basically free.It's a free tool.

Read more »

report
Use our free recommendation engine to learn which IDE solutions are best for your needs.
384,324 professionals have used our research since 2012.
Ranking
2nd
out of 9 in IDE
Views
281
Comparisons
115
Reviews
1
Average Words per Review
677
Avg. Rating
10.0
1st
out of 9 in IDE
Views
5,172
Comparisons
3,935
Reviews
13
Average Words per Review
323
Avg. Rating
8.3
Top Comparisons
Compared 82% of the time.
Compared 4% of the time.
Learn
Devart
Oracle
Overview

dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis. The tool will help SQL developers to perform complex database changes, version-control database changes in popular source control systems, and speed up routine tasks. You don't need to waste your time to search for and purchase SSMS plugins across the internet to get your work done.

Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.

For more information on Oracle SQL Developer, visit Oracle.com

Offer
Learn more about Devart dbForge Studio for SQL Server
Learn more about Oracle SQL Developer
Sample Customers
Boeing, Sony, Honda, Oracle, BMW, Samsung
Information Not Available
Find out what your peers are saying about Oracle, Devart, JetBrains and others in IDE. Updated: December 2019.
384,324 professionals have used our research since 2012.
We monitor all IDE reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
Sign Up with Email