When I publish my site the web.config of the dev version replaces the version on my target IIS 7 site. I need to release the same project to ~10 different sites with custom configs such as connection strings and log4net settings. Some of the sites share a server, but not all - so the Publish Web system is just incredibly good except for this. Now after every publish I manually go and fix each config. How can I avoid this issue?
I know I can do transformations for debug/release builds but I can't figure out how that could help during publish. Also, I really don't want to keep the custom settings within the Visual Studio project, because they are maintained directly on the release server and not in our version control.