I have several servers hosting data for the same application, and I want to see the results of the same query from different servers.
1 Answer
Yes, you can use the Script Manager to run one or more queries/scripts against multiple servers/databases.
Toad for Data Analysts has a Group execute feature built into the editor, which I personally prefer over the Script Manager.
You can learn more at Toad Executing Scripts against Multiple Databases.
-
Here's a link to see how the Group Execute works thatjeffsmith.com/archive/2010/06/…– user57725Oct 20, 2010 at 18:54