Rebaselining SQL Change Automation with Clone as Baseline

Описание: Automated Rebaselining with SQL Change Automation Clones

In this video, Kendra discusses the value of using SQL Clone as baselines in Redgate's SQL Change Automation, and how to update baseline images/clones. For the scripts shown in this video, see https://github.com/LitKnd/DontTypeInA...

00:00 About SQL Change Automation and clone baselines
02:29 Creating a new migration so that our baseline is out of date
05:12 How the baseline image is managed in the .sqlproj file, and why I prefer the approach of rotating an image but keeping the same image name
08:00 Using PowerShell to create a new image in SQL Clone
10:56 Using PowerShell to rename images in SQL Clone
12:26 Using PowerShell to move clones between images in SQL Clone, and implications of "resetting" clones when moving them
16:44 Showing SQL Change Automation working after image rotation
17:17 Showing the contents of the updated image via a newly created clone