I am using TOAD to build some reporting tools. We currently have 3 seperate SQL Server 2008 environments, each with their own connection:
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!