Then can't you just give the users a menu of different connections to choose from, depending on their user rights?

>they could all be available at the same time. Regular used would use production if they are on the network, local if they are not. The developers and testers could be using any one of the three...