title: TFS / SSDT Deployment in Multi Environment Scenario
body: <p>This is the scenario I am currently experiencing.
  In Development environment, developers usually make changes in the DEV SQL Server, then they will do a schema compare in Visual Studio 2013 / TFS, update the TFS then check the changes in.</p>
  
  <p>Now, say in DEV, there are many stored procedures in a database that refer to a database called A, however in SIT environment this database is called B.</p>
  
  <p>When I want to deploy these stored procedures from TFS to the SIT environment, is there a (automated) way to replace database A to database B, so that the stored procs do not break in SIT?</p>
  
  <p>The workaround that I did was that I generated the publish script (via TFS > Publish > Generate Script), then copy and paste that script to SSMS, replace all reference to database A with database B.
  However, this is quite manual (and not foolproof - have to be really careful what to replace), so I am wondering if there is a feature/capability to do this exercise in more efficient manner?</p>
  
  <p>Thanks in advance.</p>
  
  <p>Cheers</p>