title: Live vs Development connection strings
body: <p>We have a development database and a production database.  What I am trying to prevent is having to change:</p>
  
  <pre><code>connectionString="Data Source=server;Initial Catalog=test;
  connectionString="Data Source=server;Initial Catalog=live;
  </code></pre>
  
  <p>We have two places we deploy the site.  One for testing and one is live.</p>
  
  <p>Is there an easy way to prevent us from having to change the connection string every time we want to upload to test or live?</p>
  
  <p>We use team foundation server, I have no idea how to set up a build server or build definitions so looking for something simple if there is anything.</p>