-
Re: How to customize migration scripts in state-based approach
It's not duplicate work, to me. This is a shift left of much of the script review from post VCS in a release, to a point in time where you load the SCA project from your changes in SSC (SQL Source Co… (View Post)1 · -
Re: Problem with unnamed contraints
Honestly, what to do here is actually fix this as a part of build and fail the build if the constraint isn't named with doso standard. This for a couple things. Developers actively consider the const… (View Post)1 · -
Re: Starting DB CI - Change automation vs SQL Source Control projects
Here's a relatively short answer. I have a longer one in draft and there also is this short description: https://www.red-gate.com/library/redgates-database-lifecycle-management-approaches-a-compariso… (View Post)2 · -
Re: Azure DevOps CI/CD with SQL Change Automation
Incredibly different than .NET. Here are some thoughts, mostly distilled from experience (pre-SCA, DLM) and from working with some clients. First, branching is problematic in databases, mostly becaus… (View Post)1 · -
Re: Zero Down Time
Can I ask what changes you're making here? Specifically? Adding a column ought not to do this, but if you are doing other things, this might be an issue. There's no magic to gettting close to zero do… (View Post)1 ·