Execute One Sql Statment on Different Connections (Production / Dev etc)

Toad for SQL Server
1

I am using TOAD to build some reporting tools. We currently have 3 seperate SQL Server 2008 environments, each with their own connection:

  • Dev
  • Production
  • QA

The schema for these databases is the same. My goal is to be able to write SQL and reports which I can execute on any of the connections without rewriting them. I have not been able to find any info on this in the help other than color coding connection categories and the generated SQL has hardcoded database names.

Thanks for any and all help!

2

Hi,

have you tried Group Execute feature? seems like it is what you need.
you can find it in the editor (there is a windows for that) or while in editor go to main menu->editor->windows->group execute.
let us know if it helped you.

3

Hi!
Please refer to our online help for more information.

http://dev.toadforsqlserver.com/webhelp/Default.htm#Editor/Group_Execution_of_Scripts.htm