title: Best way to search and replace in Azure DevOps based on release stage
body: <p>I'm creating a Release pipeline in Azure DevOps which includes a dacpac deployment step. Many of the SQL scripts include a reference to another SQL Server database through a linked server. For various reasons, the database name is different on dev, UAT and production. In our source, it's hard-coded to dev, e.g.:</p>
  
  <pre><code>select * from LW.devdb.dbo.Account
  </code></pre>
  
  <p>We change the names with a manual search and replace when we do a UAT deployment</p>
  
  <pre><code>select * from LW.uatdb.dbo.Account
  </code></pre>
  
  <p>I'd like to be able to this automatically as part of the UAT stage in Azure DevOps. What's the best way to do it? </p>