We performed a comparison between IDERA SQL Admin Toolset and Toad for Oracle based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management."This product allows for much easier cross server monitoring and administration."
"SQL Server Configuration: This allows admins to compare and edit server configurations for one or more SQL servers saving a lot of time when managing large numbers of instances."
"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++."
"Simply the best GUI software for administration is the most valuable aspect for me."
"Oracle has advanced query optimization and tuning features that help improve the performance of SQL queries."
"The product's most valuable features are UI and monitoring."
"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."
"Toad for Oracle has proven to be better than other tools since we have never experienced any crashes."
"The most valuable feature of Toad for Oracle is the fashion browser and the Schema browser. It is very complete."
"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."
"A set of T-SQL admin snippets might be useful, e.g., code to create users, databases, indexes, etc. It would definitely be welcomed in the bundle."
"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."
"I would like to see an improvement in the performance because opening the browser and the editor should be faster."
"Toad for Oracle does not have a particular resolution within the application."
"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."
"The way the dialog boxes appear can be improved."
"Once in a while, I may encounter a memory exception and have to abort the application. On a few occasions, the file that stores the saved connections for the New Connection window will become corrupt and I will lose all of my saved connections. I am not sure if that is a Windows or TOAD issue, but it has happened to all of my developers at some point or another."
"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."
"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."
Earn 20 points
IDERA SQL Admin Toolset is ranked 40th in Database Development and Management while Toad for Oracle is ranked 3rd in Database Development and Management with 15 reviews. IDERA SQL Admin Toolset is rated 9.0, while Toad for Oracle is rated 8.8. The top reviewer of IDERA SQL Admin Toolset writes "Allows for much easier cross server monitoring and administration". On the other hand, the top reviewer of Toad for Oracle writes "Advanced query optimization and tuning features ". IDERA SQL Admin Toolset is most compared with , whereas Toad for Oracle is most compared with Toad Edge, Aqua Data Studio, Oracle Enterprise Manager, DbVisualizer and Redgate SQL Toolbelt.
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.