Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Edit SQL > Group Execution of Scripts

Group Execution of Scripts

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.

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.
Select the Enable Group Execute.
Select the connections you want to execute the script against in the Connection tree.
Click .
Select each connection in the Group Execute tab to display results for that execution.

Tips:

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.
To show Group Execute tab, select Editor | Windows | Group Execute.
You can also set group execution for the objects in their DOE (Database Object Editor) window. Select Enable in the Group Execution page.