September 10, 2021 at 11:35 am
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.
September 10, 2021 at 12:56 pm
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply