Likelihood to Recommend DBArtisan is functional and suitable for any sized organization that needs to monitor its database resources and running queries.
Read full review Appropriate for general querying and some DBA work. It's the universal least-offensive solution for most environments - not best of breed, but not subject to unusual/extensive requirements. It just works. On the other hand, some functionality (e.g. data import/export, snippets) are perfunctory and minimal and seem to be either difficult or impossible to automate. If you need to streamline those operations, you'll be forced to rely on third-party solutions that mostly work on top of (instead of with) TOAD.
Read full review Pros User interface is easy to use, and in some ways better than Toad. The left hand side shows all databases, and you can drill down to instance, storage, schemas, tablespaces, and performance views. The right hand side displays the details of the selected object. This is the best tool if you want to manage multiple RDBMS platforms in a single tool using the same familiar interface. Other third party tools can do it also, but it's not nearly as integrated as this, and may require additional plug-ins installed. DBArtisan excels at this, and can perform cross-platform data migrations easily. It has different DB analysts, which can help diagnose issues with performance, optimize storage, detect fragmentation, and plan for capacity growth. For almost any action you want to take, you can generate the DDL for preview, and/or schedule it to run at a specific time. Johnny Wu Senior Oracle Database Administrator
Read full review Export data into excel. Export data into excel using a pivot table functionality. Navigation between windows is intuitive and easy to understand. Good for SQL novices and experts alike. Read full review Cons Locks up far too often Licensing structure is expensive Read full review The workflow is a relatively new feature. Quest is adding additional functionality and the workflows are useful now. Would be nice if the 'Automate' feature was a bit easier to use. Would be nice if some of the SQL Editor features in the traditional interface worked better in the new workflow interface (although, these are being fixed with each release). Would be nice if there were fewer releases. Read full review Usability I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap
Read full review Support Rating I have never tried their support so the number above is meaningless
Read full review Alternatives Considered DBArtisan does not have an in-depth performance analyzer for databases.
Read full review Although Toad and
UltraEdit are both great products, from an SQL standpoint Toad is a much better editor and troubleshooter.
Read full review Return on Investment It has a positive ROI on our organization. It's better than OEM and SQL Developer. Although the license could be expensive, it is perfect for large organizations, especially with multiple RDBMS platforms. Most features are redundant between DBArtisan and Toad. I would not recommend using both if you already own one of them. Just download the trial for the one you're not using, and see what works best for your organization. DBArtisan is great for DBAs and would be my personal preference. Toad is good for developers and DBAs alike but I feel like sometimes the interface is too busy and too clumsy to use. Johnny Wu Senior Oracle Database Administrator
Read full review It is the least common denominator - not particularly optimized for our environment or workflows. Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.) Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands. It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality. Read full review ScreenShots