Toad App Reviews

I just needed a DB tool for my testing purposes. This tool is good enough for all the tasks I need to do with my local MySQL. Thanks for the free cool tool.

I dont use Toad a lot, as my main DB is MySQL and I have tools Ive used for years for that, but the ability to connect to my Oracle DBs at work without remoting into the Windows box where Navicat is installed is worth 5 stars alone. Ive never experienced the problems other users have reported (perhaps due to my infrequent use). For a free tool that connects to Oracle, this software is top notch.

Update 6/16/2016 - Still not ready for real production use. I gave version 2.4.2 a try, albeit with much lower expectations. This time around, it took a long time for TOAD to connect to the backend Oracle database, via direct host connection not using sqlnet. Probably took 30-40 seconds before the connection actually succeeded, to the point I was dropped into an editor window. Started playing a bit, noticed there is still no Export to Excel option, a very useful feature in my work. Then after a few minutes, the fan on my macbook cranked up loudly. Running Activity Monitor, I see TOAD burning up to 400% cpu, and staying sky-high. That was while TOAD was basically idle, after I had done just one simple Select statement. I quit TOAD and the cpu came back to normal. Still not ready for prime-time. ======================== Nice that Dell took a shot at creating TOAD for the rapidly exploding OSX user community, but this effort should be considered an abject failure at this point, including the 2.3.0 version. Functionality is VERY limited, the application doesn’t have any design flow, it’s just a cobbled together group of limited functions. I’d happily pay for a quality Mac version of TOAD, but this thing is pure absolute garbage right now. Oracle’s free SQL-Developer for OSX is far superior. It just seems that the Dell TOAD for OSX is a side pet project for someone who is trying to learn how to program in the OSX environment, and not a serious effort by a professional team. Honestly Dell, unless you’re going to be serious about this product, just please stop, you’re embarassing yourselves. I updated this review on 10/29/2015 to reflect the latest release 2.3.0.

Very useful software for a common usage and small databases

Toad supports SSH connections out of the box! Great! But it doesn’t support public key authentication. It only supports password authentication via SSH.

Macht was es soll… MySQL, PostgreSQL und Oracle : )

on Mac a good alternative to Oracle SQLDeveloper. So far i only knew the Windows version, the Mac version seens to be a complete redesign, much clearer and better. Only one thing is missing: the croak at startup ;)

I dont quite get why someone would make something like this. Except for the name and the logo there are pretty much no similarities between the real TOAD and this sad offspring. Youre way better off using the original Oracle SQL Developer. Please, Dell, give me a REAL, full featured TOAD for Mac, and Ill pay good money for it, but this is an absolute waste of time.

this aplication freezes.. !

Application not work on 10.10.1 yosemite :(

The layout and design of the tool are very good. Working with basic queries seems to function well, however once I start trying to run a more complex query (utilizing CTE) I start getting strange behavior. Screens just greys out and I have to do a page up/down to see text and the results never show up. Also the program just freezes when running more complex queries sometimes. I on Maveric connecting to a Postgres (9.2) database. Would love to see these issues fixed as I would most certainly use this as my primary tool for working with Postgres.

and it havent been able to get it to load past halfway since then.

I like Toad on the PC, but this just doesn’t cut it on the Mac. The editor is incredibly sluggish (typing should not *ever* be laggy!) and the app crashed within a few minutes of editing a package body, losing the work. Thankfully I hadn’t done much yet, so it wasn’t a great loss, but this should *never* happen.

Overall, this does seem to get the job done most of the time. The layout is decent (and certainly much prettier than the Windows counterpart), and the editors work as expected. Unfortunately, I have more complaints than anything else: - I manage a lot of different connections, and having to go into Manage Connections > Gear > Connect seems awfully verbose to just connect to a saved connection. - You can connect to multiple databases at once, but I would not recommend doing so. The layout of the software makes it incredibly unclear as to which connection you are currently working with. - It is unclear when exactly changes made in this editor are committed to the database. You can disable autocommit on a connection-by-connection basis, but even if you do that there is no "Commit" button like in Windows. Rather, it seems to commit whatever changes you made as soon as you close the editor/browser tab. That would be fine, except there is no obvious way to revert unwanted changes, so be very careful what you click! - If I forget to shut down the application before putting the computer to sleep, the disconnection from WiFi usually causes the application to stop responding, and I have to Force Quit the application and restart it. Fortunately, Toad does do a good job of recovering whatever I was working on last. - The search filter above the connection browser does not seem to do anything whatsoever, and scrolling through hundreds of databases is a real bummer (adding databases to Preferred Schemas does help with this somewhat). Overall this application is SO CLOSE to being awesome. The connection browser is much better overall when compared to the Windows version (in my opinion). Having actual text for the categories like Sequences, Triggers, etc. is so much better than guessing at tiny symbols. I think a few small tweaks could go a long way for this application. One last note - our database admins have developer tools disabled for production databases, preventing Toad from accessing them on Windows. However, this setting does not seem to affect the Mac version for some reason.

I have the windows version and its greate for MS SQL, please support MS SQL in the mac version, without it this is not a complete program.

This is a really good piece of software to work with databases, a lot better than SQLDeveloper if I have to say, I only have two little concerns about two really basic features: 1. It’s almost impossible to do Command + C to copy some text in almost every ‘view/component/sub-window’. I really think that this is pretty basic, how could not work on your program? are we in 1990? 2. It’s fails opening files, I dont care if I rebooted my Mac or if I kill (force close) the software or just close the program in regular basis but when a user open Toad and choose the option "OPEN FILE" never should get a "Could not read file" when reading a perfect functionally file. You need to make your program avoid whatever is happening inside to your users and just open the file. I can open it with every program I choose but yours. It is even worse when the program fails to open the file, the file get this anoying tag "com.apple.quarantine" Those are my only comments on Toad, which still beign a great program. But this two pretty basic issues keep me using SQLDeveloper.

As of the Oct 2 update I can no longer connect using a SID. The connection setup defaults to Service name regardless of the option you choose. Please fix this in the next release. Other than this (and once I can connect again) I am loving having a Mac version of TOAD. It needs some more capibilites like the PC version but it is a very good start and already is better than SQL Developer.

I come from an SSMS background, and living up to that UI is a tall order. One thing that I like about Toad is that you can hit Command-Enter to run the current SQL Statement. You don’t even need to highlighte the statement. Cool! What I like the least so far is copying and pasting from the grid results. It’s a real pain. You have to right-click a cell to copy it’s contents and cannot use Command-C. Exporting results is cumbersome as well. Also, just a little thing, but when I save an SQL file I often copy the name of the object from my SQL Syntax and then paste that as my filename in the save-as dialog. This does not work. Basically it feels very non-native to the Mac OS X UI.

Problem 1: Toad supports SSH connections out of the box! Great! But it doesn’t support public key authentication. It only supports password authentication via SSH. Problem 2: Toad does not support Materialized Views for PostgreSQL. Not just that, but they’re entirely invisible in the interface. You’d never know they were missing. Unfortunately, problem 2 is a non-starter for my environment, even working around problem 1.

I’m looking for a postgres manager that’s better (more Mac-like) than pgAdmin3. This is a fairly good start, but it has a long way to go. Good: It’s free and functional. When auto-complete works, it works nicely. Not so good: It’s clearly eclipse underneath the skin. As such, it suffers from all of eclipse’s usability problems on Mac OS X. The auto-complete is easily confused, and pops up at inappropriate times (causing input focus to shift to random areas of the screen). Bad: After building a query in it for about 15 minutes, it became unstable, consuming 2GB of memory and 1 CPU core. After a restart, my unsaved work was lost.