My previous posts discussed why you need automated database deployments and tips for getting started down that path. Enough talk, it is time for action! This article will walk through setting up an automated database deployment pipeline using the state-based approach for Redgate’s SQL Change Automation. I picked this tool to start with because it is easy to set up, integrates with SSMS, and…well…I already had a demo set up. I’m also a little biased towards Redgate’s tooling. So there’s that.
The end goal of this article is for you to have a working proof of concept for you to demo.