We performed a comparison between Devart dbForge Studio for SQL Server and Oracle SQL Developer based on real PeerSpot user reviews.
Find out what your peers are saying about GitHub, Amazon Web Services (AWS), JetBrains and others in IDE."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."
"The newer version has a lot of new features. It generates output and scripts for your Ultrix. It can generate JSON, XML, etc."
"The most valuable features of Oracle SQL Developer that I use. However, I do not use all of them"
"Ability to analyze performance, using Explain Plan statement."
"I have a lot of flexibility with it."
"You do not have to install it, just dump it on the OS, then use it."
"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."
"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."
"Using execution plan, I am able to do lots of query tuning."
"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."
"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."
"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."
"It would be nice to have the ability to access DBs than Oracle."
"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."
"The initial setup is always a problem, it cannot find the Java SDK."
"If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager."
More Devart dbForge Studio for SQL Server Pricing and Cost Advice →
Earn 20 points
Devart dbForge Studio for SQL Server is ranked 9th in IDE while Oracle SQL Developer is ranked 4th in IDE with 30 reviews. Devart dbForge Studio for SQL Server is rated 9.0, while Oracle SQL Developer is rated 8.6. 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 "This product is delivered at no cost to us as Oracle users. We even have non-tech, functional users installing it on their own with only a little guidance from us". Devart dbForge Studio for SQL Server is most compared with dbForge Studio for MySQL, whereas Oracle SQL Developer is most compared with Toad Data Modeler, SonarLint, Delphi, JetBrains IDEs and Eclipse Luna.
See our list of best IDE vendors.
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.