mbourgon<p>Hey <a href="https://dataplatform.social/tags/sqlfamily" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlfamily</span></a> , curious how everybody is doing Ci/CD. I want to do it. I’ve checked in everything in prod into GitHub. I have access to GitHub Actions. But what do people do to get from dev to prod? If I change a table and add a permission, what scripts out the changes from my dev DB? Looks like Sqlpackage and Flyway? If I can’t have the database look like prod (because of extra audit triggers, etc), how should I handle that? Is there a Recommended Best Practice somewhere? <a href="https://dataplatform.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a></p>