Toad World Blog

Toad DevOps Toolkit Sample Scripts

Jun 22, 2018 4:58:46 PM by Quest Software

Here are the available sample scripts for Toad DevOps Toolkit.

 

Sample Script Description
PL/SQL

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 (see Oracle 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.

PowerShell

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.

VBA (Visual Basic for Applications)

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.

Tags: Toad DevOps Toolkit DevOps Samples

Quest Software

Written by Quest Software