DbVisualizer is a multi-database tool for developers, analysts and database administrators, providing a single interface across a wide variety of operating systems. Boasting an easy-to-use and clean interface, DbVisualizer runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.
$0
Toad Database Developer Tools
Score 8.0 out of 10
N/A
Toad by Quest is a database management toolset that database developers, administrators and data analysts use to simplify workflows, create code free from defects, automate frequent or repetitive processes, and minimize risks. Editions include Toad for Oracle, which automates administration tasks and helps proactively manage databases while embracing performance optimization and risk mitigation. Similar editions exist for IBM DB2, SQL Server, SAP, or MySQL and Postgres environments (Toad Edge).
$229
per year
Pricing
DbVisualizer
Toad Database Developer Tools
Editions & Modules
DbVisualizer Free
$0
DbVisualizer Pro with Basic support - Renewal
$89
per year per user
DbVisualizer Pro with Premium support - Renewal
$119
per year per user
DbVisualizer Pro with Basic support
$199
per year per user
DbVisualizer Pro with Premium support
$229
per year per user
Toad Edge For MySQL
$229
per year
Toad Edge For Postgres
$229
per year
Toad for SQL - Pro Edition
$437
per year
Toad for Oracle - Base Edition
$550
per year
Toad for DB2 z/OS - Base Edition
$636
per year
Toad for SAP - Base Edition
$636
per year
Toad for SQL - Xpert Edition
$763
per year
Toad for Oracle - Professional Edition
$829
per year
Toad for SQL - Dev Edition
$930
per year
Toad for DB2 z/OS - Pro Edition
$996
per year
Toad for Oracle - Professional DB Admin Edition
$1,370
per year
Toad for DB2 z/OS - Xpert Edition
$1,529
per year
Toad for SAP - Xpert Edition
$1530
per year
Toad for Oracle - Xpert Plus Edition
$1,753
per year
Toad for DB2 z/OS - Dev Edition
$1,861
per year
Toad for SAP - Dev Edition
$1863
per year
Toad for SAP - Xpert+ Edition
$2099
per year
Toad for SAP - DBA Edition
$3661
per year
Offerings
Pricing Offerings
DbVisualizer
Toad Database Developer Tools
Free Trial
Yes
Yes
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
Optional
No setup fee
Additional Details
New license cost includes a perpetual license, software upgrades and support for the length of the term. 1, 2 & 3 year terms are offered. Once license expires the user may access all Pro versions released before the license expiry indefinitely. To gain access to Pro versions released after the license expired, license renewal is offered. Volume discounts apply to both new and renewal licenses.
—
More Pricing Information
Community Pulse
DbVisualizer
Toad Database Developer Tools
Features
DbVisualizer
Toad Database Developer Tools
Database Development
Comparison of Database Development features of Product A and Product B
DbVisualizer
7.8
Ratings
9% below category average
Toad Database Developer Tools
8.5
Ratings
0% below category average
Performance optimization tools
7.70 Ratings
9.00 Ratings
Schema maintenance
7.90 Ratings
9.00 Ratings
Version control tools
00 Ratings
8.90 Ratings
Test data generation
00 Ratings
6.00 Ratings
Database change management
00 Ratings
9.50 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
Well suited for medium size to large Oracle system that includes a large and complex database schema with many database objects including functions and triggers. Also well suited for a medium size to large Microsoft SQL Server system with many complex database objects. Its SQL editor and query builder are well suited in developing complex SQL queries.
Well suited for development of stored procedures, packages, running scripts, and each and every DBA operation. Not very well suited for quick and simple querying. Toad seems to be overkill for simple things. Also, it's not very well suited for non-Oracle developers, who might be scared of by the endless amounts of options, tools and windows that Toad offers.
I appreciate the library feature that enables me to label and store previously created statements. These are saved off to a network share for future use.
I also really like the describe function that lists all fields in a table. This helps as I build new queries.
I wish I was better at using the tuning function. I have seen others use it and am very impressed with the graphical depiction of query costing.
does not handle lost connections well (specially after stopping a running query) (mysql). eg. after hitting stop, and then hitting run again, it can sometimes look like its running the query, but it isn't actually!
filtering on databases window is clunky (why the need for filtering certain object types at a time? just filter everything, google style)
altering table, adding columns (NOT to the end of the table's columns, but earlier) is not supported (mysql) even though the db supports it (alter table add column BEFORE..)
The date/time settings in Toad are kind of difficult to figure out. I have to use an ALTER SESSION command to format the dates so I can actually query date/time fields.
It seems to be updated too often. I get notifications very frequently about new versions being available.
I use this tool for several hours each day, spanning many years in various projects. It's wide support for various database types while keeping consistency within the UI for each is important when working with various databases day in and day out.
I give is an 8 because nothing is a 10 and there is always room for improvement. I believe the user who is not as technologically inclined would be better suited with an easier way to identify the options for setting the layout up for Toad's GUI. To some it is very cumbersome and confusing.
I give the overall support for Toad for Oracle a 10/10. This is because whenever there has been an issue with this software, our team has got an immediate response. The same can not be said for similar software. The most recent example of this is when we needed to renew our licenses. Some employees were unable to log in to code with the given license key. Support was able to resolve the issue quickly.
[DbVisualizer] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.
We didn't make a decision of choosing one and dropping the other. Our database guys have their own preference of tools. Since SQL Developer is a free-to-use tool and light weighted tool, we used it for education materials. For those who need advanced functions, database administrators for example, we bought an enterprise license of Toad and distributed them to developers. For enterprise level of analytics running Oracle based databases, I believe SQL Developer and Toad are two basics and safe choice to start with, unless one has very particular need (or preference).
The only point I could potentially give is hours saved by having so many warehouses hooked up in one place vs. having to manage connection string changes/password updates across multiple applications... maybe 10% decrease in time spent managing connections? Mind you, I've had everything hooked up on DbVis for close to 6 years so it's hard to remember the "before times"
Quick and easy query development helps reduce man-hours in a project which converts to real dollars.
Query analysis and tuning result in low database overhead and low latency, thus translating into real dollars because a system can thus handle more requests from customers.
Ease of use makes it easy to deploy greenhorns in projects with minimal training, thus helping save money. Otherwise menial and simple jobs would have required experienced DBAs.
