Last week’s blog was the first in a series about how to make Toad run scripts or commands against multiple databases at once. Lots of people did not know that there are multiple ways in Toad to do this. This week I’ll highlight the second method of running scripts against databases using the “Toad Project Manager”. 
 
You simply switch to Project Manager’s Connection tab as shown below, “multi-select” the connections you want to execute something against, and then via the right-hand-mouse context menu choose either a “Quick Script” from the Script Manager, or a Named SQL. That’s all there is to it. 
 
You’ll then see output from both databases as shown below (i.e. two script editor windows with the script executed against each database). For those not yet familiar with the Toad Script Manager, review last week’s blog. Also look at the second screen snapshot below of the Script Manager’s screen and Toad’s main menu toolbar icon. The items on the Script Manager screen checked as “On File Menu” are then shown both under the toolbar icon and Project Manager’s right-hand-context menu (both shown). So remember – in the weeks to come I’m going to demonstrate other ways to execute SQL scripts against multiple databases at once, so please tune in