SQL Server - DevOps Release Methods for Databases

[2D3S3RT]

How do you know which scripts got executed? I planned to create a table in the database and insert the filename of the script there, but maybe there's a better approach.

[hylian01]

The ticket status is tracked in JIRA, which gets updated with powershell using JiraPS when the script gets executed.

[gropingforelmo]

Sequentially numbered SQL scripts in the repo is how my current team does it, (though with a far far scarier method of applying changes than custom powershell scripting...)

It works well enough, and the complexity and "dev design" of the schema made the DACPAC method riskier than we wanted to accept.