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."It's quite easy to install and use from a local machine or laptop, as well as on a server."
"I like the ease of use and quick data usage."
"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."
"The most valuable features of Oracle SQL Developer that I use. However, I do not use all of them"
"It allows us to implement a form of test driven development (TDD) for database-resident code."
"Ability to analyze performance, using Explain Plan statement."
"Using execution plan, I am able to do lots of query tuning."
"I have a lot of flexibility with 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."
"The newer version has a lot of new features. It generates output and scripts for your Ultrix. It can generate JSON, XML, etc."
"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."
"The initial setup is always a problem, it cannot find the Java SDK."
"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."
"If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager."
"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."
"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."
"There are occasional runtime issues that are easily worked around, especially on a Windows deployment."
"There is room for improvement in the Real Time SQL Monitoring."
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, IDERA Rapid SQL 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.