title: How to build CI/CD for MS SQL Server?
body: <p>I'm trying to build a CI/CD for my Microsoft SQL Server database projects. It will work with Microsoft DevOps pipelines.</p>
  <p>I have all databases in Visual Studio databases projects with the GIT as source control. My objective is to have something that I can release databases with the use of DevOps pipelines to the diferents enviroments:</p>
  <ul>
  <li>DEV</li>
  <li>UAT</li>
  <li>PROD</li>
  </ul>
  <p>I was thinking of using DBGhost: <a href="http://www.innovartis.co.uk/" rel="nofollow noreferrer">http://www.innovartis.co.uk/</a> but I can't find updated information about this tool (only very old info) and there is very little information about it on the internet and how to use it (is it still in use?).</p>
  <p>I would like to use a mix of DBGhost and DevOps. DBGhost to Source Scripting, Building, Comparing, Synchronizing, Creating Delta Scripts, Upgrading and DevOps to make releases (that would call the builds created by DBGhost)</p>
  <p>If you have any ideas using this or other methods I am grateful because currently all releases are manual and it is not very advisable to do.</p>