Currently I can easily setup Web.config transform based on build configuration, e.g. use connectionString=server;..
for Debug
and connectionString=./SQLExpress;..
for Release
.
But is it possible to do some Web.config transformation basing on web publish profile? I.e. use connectionString=server1;..
for profile Server1
and connectionString=server2;..
for Server2
?
I believe that the publishing profiles are independent of the build profiles, which is a bit of a shame, as you could easily accidentally deploy a debug configuration to your production servers.
However, if you're using MSDeploy, there are ways to modify the web.config in there. See MSDeploy - Changing Connection string parameter after deploying the package for more details.