Changing the SQL Session state connection programmatically

[Thina]

My application uses SQL session state. In Test Server the session state
would be pointing to Test DB Server, similarly the Prod Server to Prod
DB Server. Is there a way to programatically change session to point
Test DB to Prod DB Server? That is, I would use the same web.config
file. So, no matter where the code resides the web.config remain same.
For normal connections this can be achieved by recognizing the server
name, but that is done during runtime, it is not the matter with
session state as it needs to be initiated at compile time.

Any help would be appreciated!

Thanks!

Thinagaran