Capture dacpac version history

  • Thanks Phil, the simplest solution is often the best and I can't think of an edge case that I couldn't work around with that solution.

  • It all depends on how the dacpac is applied. If people are just right clicking in SSMS, your level of control is zero. If there's a script that is used, just implement the version numbers, table or extended properties, into the script. Most of the time, for me, automated deployments are controlled through some kind of flow control, Octopus, AWS Developer Tools, Azure DevOps, whatever. That lets you have multiple steps for the automation, so you can do more.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply