How can we help you today? How can we help you today?

Post-Deployment Script not working

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.
tomslickers
0

Comments

3 comments

Sort by
  • 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?
    Jessica R
    0
  • 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.

    tomslickers
    0
  • Jessica R
    So glad you tracked down the issue @tomslickers and thanks for sharing the solution! :)
    Jessica R
    0

Add comment

Please sign in to leave a comment.