Toad DevOps Toolkit Sample Scripts

This sample script will demonstrate how PL/SQL can be used to call TDT commands and return results.

In order to run TDT using PL/SQL, several Oracle installation steps are required (seeOracle COM Automation Feature (PDF) or Oracle COM Automation Feature (web) for more information).

The demo will show how to:

1. Start TDT.
2. Get Connection Property.
3. Set Connection Arguments.
4. Make a Connection.
5. Stop TDT.

This .zip file contains 2 files – TDT_demo.sql and a Readme.pdf document.

These sample scripts will demonstrate how PowerShell can be used to call TDT commands and return results. 

The examples provided show how to:

1. Check Database Connections.
2. Run Code Analysis.
3. Run Execute Script.
4. Run Compare Databases.
5. Run Compare Schemas.
6. Run Compare Tables.
7. Run Unit Testing (using Code Tester).
8. Run Debug.

This .zip file contains a number of example .bat and .ps1 files, along with a Readme.pdf.

This sample script will demonstrate how Visual Basic for Applications (VBA) can be used to call TDT commands and return results to an Excel spreadsheet.

The demo will show how to:

1. Start TDT.
2. Connect to a Database.
3. Execute a Query.
4. Return results to an Excel spreadsheet.
5. Stop TDT.