Installation
System Requirements
Install Toad
Specify App Data Directory Location
Read-Only Installation
Install Toad Silently
Install Toad on Citrix Systems
Upgrade Toad
Upgrade Automation Scripts
Files Migrated During Upgrades
Uninstall Toad
Configure Toad Layouts
Create Connections
Understand Toad Connections
Create Access Connections
Create BusinessObjects Connections
Configure DB2 Client Connections
Configure DB2 LDAP Support
Create DB2 Connections
Create Excel Connections
Create SharePoint Connections
Create Google Analytics Connections
Create Hive Connections
Create Intelligence Central Connections
Create MySQL Connections
Create ODBC Connections
Configure Oracle LDAP Support
Create Oracle Connections
Create Oracle BI Connections
Create PostgreSQL ODBC Connections
Create Salesforce Connections
Create Snowflake Connections
Create SQL Server Connections
Create SSAS Connections
Create SAP Connections
Create SAP HANA Connection
Create Teradata Connections
Troubleshoot Connections
Troubleshoot Access Issues
Troubleshoot Hive Issues
Troubleshoot Excel Issues
Troubleshoot DB2 LUW Issues
Troubleshoot DB2 z/OS Issues
Troubleshoot Informix Issues
Troubleshoot MySQL Issues
Troubleshoot Oracle Issues
Troubleshoot SQL Server Issues
Troubleshoot Sybase ASE Issues
Configure Version Control
Execute SQL on Multiple Servers/Instances
You can execute a script in the current Editor window against multiple servers or multiple instances on a server. For example, if you need to add new tables to your company's development and test databases, you can execute the same script against both databases at the same time using this feature.
Note: This feature does not support cross-platform execution.
To execute scripts against multiple servers/instances
- Enter the script in the Editor window.
-
Select the Group Execute tab on the left side of the Editor window.
Note: To display the Group Execute tab, select Editor | Windows | Group Execute
- Select Enable in the Group Execute pane. This action displays your defined connections in the Group Execute pane.
- Select the connections to execute the script against.
- Click
.
- Results for all connections display in the Results pane. To display results for an individual connection, select the connection in the Group Execute pane. To display all results again, select the connection type node again.
Tips:
- To show/hide the Group Execute pane by default, go to Tools | Options | Editor | Tools.
- When saving an Editor file where Group Execute is enabled, Toad defaults to saving the file as a Toad Editor File (.tef). If you save as this file type, the selected connections group, script, results, and any filters are also saved in the file.