Monday, June 6, 2016

right-click on a database in SSMS and pick "Link database to source control..."

...to do exactly what you'd expect. The database can then be kept up to date by way of scripts checked into source control. Click the "SQL Source Control" button in SSMS at the top nav for tabs such as "Get latest" for getting the latest changes, etc.

 
 

Addendum 6/8/2016: Under the "Get latest" tab there will be a left pointing arrow for: "Update the database with latest changes from source control"

No comments:

Post a Comment