Answers: <p>I assume from the <code>ansible</code> tag in your question that you need something that can run from a command line, so that rules out plugins to SSMS like <a href="https://sqlserver.pro/dbforge-sql-server-schema-comparison-and-sync-tool" rel="nofollow noreferrer">dbForge</a>. </p>
  
  <p>Try <a href="https://flywaydb.org" rel="nofollow noreferrer">Flyway</a> (has a free version) or <a href="https://www.red-gate.com/products/sql-development/sql-compare/" rel="nofollow noreferrer">Red Gate</a> (commercial). </p>
  
Answers: CC BY-SA 4.0
Answers: 2019-09-01T17:35:29.503Z
Answers: 2019-09-01T17:35:29.503Z
Answers: Gaius
Answers: <p>Did you try DbUp?
  <a href="https://dbup.readthedocs.io/en/latest/" rel="nofollow noreferrer">DbUp homepage </a> 
  This utility can apply patches to database and maintain its version. </p>
  
  <p>It writes execution log to databases and is able to run scripts that were not applied. </p>
  
  <p>I'm using that project over 3 years now and it does it job well. </p>
  
Answers: CC BY-SA 4.0
Answers: 2019-08-01T22:17:21.810Z
Answers: 2019-08-01T22:17:21.810Z
Answers: profesor79
Body: <p>I am looking for a tool that will manage the versioning of Azure SQL Databases, and check for missing schema or migration scripts and apply those changes based on what is missing.</p>
  
  <p>Any other solutions or tips would be great. I just want to make sure the database schema is flat across the board regardless, and apply changes based on version number.</p>
  
  <p>Any suggestions?</p>
  
Tags: <ansible><chef><azure>
Title: How to manage the versioning of Azure SQL Databases?
UserDisplayName: smorris
ThreadText: # How to manage the versioning of Azure SQL Databases?
  
  (Asked by: username_0 on 2019-07-01)
  
  I am looking for a tool that will manage the versioning of Azure SQL Databases, and check for missing schema or migration scripts and apply those changes based on what is missing.
  
  Any other solutions or tips would be great. I just want to make sure the database schema is flat across the board regardless, and apply changes based on version number.
  
  Any suggestions?
  
  **Tags:** ansible, chef, azure
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2019-09-01. Score: 1
  
  I assume from the `ansible` tag in your question that you need something that can run from a command line, so that rules out plugins to SSMS like [dbForge](https://sqlserver.pro/dbforge-sql-server-schema-comparison-and-sync-tool).
  
  Try [Flyway](https://flywaydb.org) (has a free version) or [Red Gate](https://www.red-gate.com/products/sql-development/sql-compare/) (commercial).
  
  
  ---
  
  ### Answer by username_2 on 2019-08-01. Score: 0
  
  Did you try DbUp?
  [DbUp homepage](https://dbup.readthedocs.io/en/latest/) 
  This utility can apply patches to database and maintain its version.
  
  It writes execution log to databases and is able to run scripts that were not applied.
  
  I'm using that project over 3 years now and it does it job well.
  
  
  ---
  
  