Enivronment Based Web.config ! This is Tricky !! Any brilliant Ideas??

[nom84]

Hi there
So far they way we have been using web.config on all our servers is like mostly how everyone does it. But now we need environment based web.config. At the moment we have one web.config with different values for the same keys on different servers. For example, we can have one connection string Key for the local webconfig which is pointing to the local database. When it goes to the server we have to change the connection string to point to the db on the server.

Now i require a way to have same web.config on all the servers where i just upload the web.config without the need to change the values it should just pick the values correctly depending on the server its on or the machine it is on. So it will be preloaded with all the required values for every server and it should pick up the right values based on the environment its running in.

I know its confusing so is there an easier way of doing this?? or any way at all??

Any help will be appreciated.

Thanks
Nom