IT:AD:XDT:HowTo:Transform Connection Strings
Summary
Having a different connection string per dev and/or per environment has to be one of the most annoying problems a Team Lead has to define a working strategy at the beginning of a new project.
Process
After having generated a XDT for your ST or release environment
edit the app.config.{env} file:
<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
<connectionStrings>
<add name="ICS-Database"
connectionString="server=258SPIKES;database=SNZ.ICS.ST;Integrated Security=SSPI;"
xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>
</connectionStrings>
</configuration>