Post-Deployment Script not working

tomslickers

I created a simple Post-Deployment Script that creates a job, and committed it to Git using SQL Source Control. I confirmed that this is in Git in a new folder Custom Scripts/Post-Deployment.

When I run my build/deploy process, nothing happens.

I'm using Jenkins with a PowerShell script (attached) to validate the schema and create the NuGet package. This later gets pushed to Octopus where I'm using the latest Step Templates (RedGate - Create Database Release and RedGate - Deploy from Database Release). I'm running SQL Change Automation 3.1.3.3059.

Jessica R

Hi @tomslickers,

Thanks for your post and sorry to hear you're running into an issue!

I did a quick test and this was working alright on my machine. If you use the Export-DatabaseRelease cmdlet in your powershell script, it will export the release artifacts including Update.sql - this is the script that is executed on the target server to make the changes. Can you kindly take a look at the generated script to see if it includes the post deployment script?

tomslickers

@Jessica R

Thanks for your reply. After I saw this I realized that although I upgraded from DLM Automation to SQL Change Automation on our build server, our PowerShell script was still running the old DLM cmdlets. Once I changes to the new versions everything started working.

Jessica R

So glad you tracked down the issue @tomslickers and thanks for sharing the solution!