One of the more frequent questions people ask me is why can’t Toad run scripts or commands against multiple databases at once? Of course as usual the answer is Toad already can – so I’m going to dedicate the next couple weeks’ blogs to this topic. 
 
This week I’ll highlight the first method of running scripts for multiple databases using the “Toad Script Manager”. It has been in Toad for a long time now – and it’s available off the Main Menu as pointed out below. You simply create a grouping of scripts (in this case I told Toad to point to my “C:\Bert\SQL” directory – where I keep all my SQL scripts from over 20 years of Oracle work. Then I simply indicate to the Script Manager that I want multiple connections active when I execute the selected item. That’s all there is to it. You’ll then see output from both databases as shown below. 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