调试经验——Toad两年使用体验小结

使用Toad已有两年多了，今天做个简单总结。

平时怎么使用Toad的？

1. 如果要刷新常规报表，则选择多个脚本文件，一次打开，然后按照报表操作说明，依次执行各个脚本文件。

2. 每次执行完一个脚本文件后，将查询结果导出到Excel Instance中，导出完成后，直接CTRL+A全选，然后CTRL+C复制到工作文件中。

3. 完成SQL的更新（包括调试）

4. 完成各种数据分析（数据质量问题原因排查，探索性数据分析，学习型数据分析等）

5. 批量执行SQL语句（使用Quest Script Runner命令）

6. 比较脚本文件不同版本间的差异（Compare Files）

7. 调整SQL语句格式（即， Format Code命令，自动缩进、换行、大小写转换等）

以上只是Toad功能的冰山一角，感觉还有大量的功能有待于进一步挖掘。

以下关于Toad软件的介绍摘自Wikipedia，供各位参考。

-------------------------------------------------------------------------------------------------------------------------------------------------------

Toad is a database management toolset from Quest Software that database developers, database administrators, and data analysts use to manage both relational and non-relational databases using SQL. There are Toad products for developers and DBAs, which run on Oracle, SQL Server, IBM DB2 (LUW & z/OS), SAP and MySQL, as well as, a Toad product for data preparation, which supports most data platforms. Toad solutions enable data professionals to automate processes, minimize risks, and cut project delivery timelines.

Features

• Connection Manager - Allow users to connect natively to the vendor’s database whether on-premise or DBaaS.
• Browser - Allow users to browse all the different database/schema objects and their properties effective management.
• Editor - A way to create and maintain scripts and database code with debugging and integration with source control.
• Unit Testing (Oracle) - Ensures code is functionally tested before it is released into production.
• Static code review (Oracle) - Ensures code meets required quality level using a rules-based system.
• SQL Optimization - Provides developers with a way to tune and optimize SQL statements and database code without relying on a DBA. Advanced optimization enables DBAs to tune SQL effectively in production.
• Scalability testing and database workload replay - Ensures that database code and SQL will scale properly before it gets released into production.