Running queries over multiple environments?

["Lois White" <lwhite@xxxxxxxxxxxxxxxxxx>]

  I was wondering if anyone has a solution to having to change all their
queries that are pointing to a specific environment when a new environment
is created.  We create multiple environments through out the year for
separate functions and each one is a full environment that has to work
independently.  This means going into several hundred queries and changing
the file libraries, which becomes a long boring job that is a waste of time
and man power.  Do I need to change them all to query management queries to
run over a library list or is there some kind of neat tool or in house
solution out there?  Any suggestions would be greatly appreciated.

 

Lois White