We performed a comparison between Quest Spotlight and Toad for Oracle based on real PeerSpot user reviews.
Find out in this report how the two Database Development and Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The tool is a SaaS product where I just need to type a URL and start with the design process. I can integrate all elements of source control like GitHub, GitLab, etc. The tool also supports authentication-related provisions like SSH."
"Its dashboards are most valuable. The drill-down of the dashboards is useful."
"I consider the solution very scalable."
"The schema browser is the most valuable feature. The way it presents the objects in our database."
"Simply the best GUI software for administration is the most valuable aspect for me."
"The most valuable feature is the navigation within the UI, where you can right-click on an object in an SQL query and go right to it, versus going through all of the menus to find what you are looking for."
"I find Toad easy to use and I love the Workspace feature, which allows me to set up projects so that I can open SQL files applicable to what I am working on at any particular time."
"Toad has a lot of features that are very useful, fast, and well developed."
"The product's most valuable features are UI and monitoring."
"A quite simple feature that I have not encountered elsewhere is the "Make Code" feature. I can easily export a complex SQL statement to a programming language. This is a great timesaver as I do not have to type in all of the escape/concatenation characters just to create a SQL statement in C# or C++."
"Oracle has advanced query optimization and tuning features that help improve the performance of SQL queries."
"Some customizations of the dashboard, such as having backup reports, would be useful."
"There's no reporting with this tool, and there really should be. They should add that into future releases."
"The software does not support webhooks. It doesn't support advanced versions of APIs. The tool also doesn't support advanced versions of specifications. The change that we do in one part of the model is not reflected throughout the specification. There are also some mutations in the clones. I am not able to do a local source control with the product as well."
"It would be better if they had an online option allowing me to connect from anywhere on any device. Sometimes I face some errors, depending on the network and setup. It's not a big issue."
"Improvement wise, for the user it should show the minimum features on the screen and not all the features. Toad has a lot of features, but most users will use only 5 or 10 based on their role. Nobody needs all the features, and they should provide the option to choose only the required features. Only minimum requirements should be enabled by default. When all the features are shown, the performance is not good; it loads slowly and has hundreds of popups and unnecessary questions."
"Sometimes it works in some areas, but in others, it doesn't. Like when you copy, you find that it's blank and doesn't copy anything. So, there are some objects that do copy, and sometimes they don't."
"There should also be a better "cancel query" option as sometimes one cancels a query, but then it still might run for a long time, and then one has to crash Toad in order to cancel the query."
"An area where the solution could use some improvement is in terms of user-friendliness. During the initial setup phase, the solution was not very intuitive when attempting to establish connections."
"I'd like reporting to be more available. If it was a feature that was already installed, more people would take advantage of it."
"In future releases, the product can be more intuitive. It has to be lighter than what it is because sometimes it is not responding quickly. If I do some features at the same time, it's not supporting. I have to wait sometimes to get the action. It's dependent on the resources of the workstation, but it has to be improved in this area. The faster processing is needed."
"Query optimization is still very resource-intensive."
Quest Spotlight is ranked 5th in Database Development and Management with 4 reviews while Toad for Oracle is ranked 3rd in Database Development and Management with 15 reviews. Quest Spotlight is rated 8.8, while Toad for Oracle is rated 8.8. The top reviewer of Quest Spotlight writes "Good tool for the design and development of public APIs". On the other hand, the top reviewer of Toad for Oracle writes "Advanced query optimization and tuning features ". Quest Spotlight is most compared with Quest Foglight for Databases, Oracle Enterprise Manager, Redgate SQL Toolbelt, SolarWinds Database Performance Analyzer and IDERA SQL Diagnostic Manager for SQL Server, whereas Toad for Oracle is most compared with Toad Edge, Aqua Data Studio, Oracle Enterprise Manager, DbVisualizer and Redgate SQL Toolbelt. See our Quest Spotlight vs. Toad for Oracle report.
See our list of best Database Development and Management vendors.
We monitor all Database Development and Management 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.
