Item: Toad Database Developer Tools
Rating: 8
Author: SUbrat Mishra

Use Cases and Deployment Scope

Toad is currently used by our DBA team and some of the development teams. It is primarily used for SQL building, SQL tuning exercises. We are also using it in DB design tasks. DBAs primary use it in their day to day operation. It is only used by oracle DBA team now. They use this to pull session information also.

Pros and Cons

SQL Formatting
Running multiple SQLs as multithreading operation
Data extract exports

Better syntax error information
Auto tracing options

Return on Investment

It is really helpful for my DBA team.

Alternatives Considered

SQL Developer has been used significantly by the development team for their sql designing and development.

RedGate is primarily used for ms sql and for CICD pipeline. We also use liquibase for our change deployment to automate the cicd. Toad is better to compared the both these tools and may be the license cost can be reviewed.

Support Rating

I would like to support this tool, because of its features particularly used by DBAs for user management, SQL tuning, schema management, db change management. It's multithread sql execution is a nice feature to run multiple sqls against a database and compare the data easily. It can be more changed for dev teams.

Key Insights

Do you think Toad Database Developer Tools delivers good value for the price?

Yes

Are you happy with Toad Database Developer Tools's feature set?

Yes

Did Toad Database Developer Tools live up to sales and marketing promises?

Yes

Did implementation of Toad Database Developer Tools go as expected?

Yes

Would you buy Toad Database Developer Tools again?

Yes

Other Software Used

Oracle SQL Developer

Likelihood to Recommend

Toad is well suited with Oracle as it provides a mechanism to run multiple sqls at the same time against a single database. Performance and memory management of the tool is particularly good. The way it provides the explain plan generation is really handy when a developer needs to analyze their sqls in lower environment. It is also handy for DBA team for their daily operational tasks.

Toad For Oracle - Way to Go

Overall Satisfaction with Toad for Oracle