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

Rollback Deployment

How can we rollback a deployment through Team City and is there any option to take Backup of database prior to deployment changes?
Vijay
0

Comments

1 comment

Sort by
  • AlexYates
    How have you set up the deployment to work in TeamCity?

    To create a backup (more reliable, involves downtime):
    If using SQL Compare command line: https://documentation.red-gate.com/display/SC12/Switches+used+in+the+command+line#Switchesusedinthecommandline-/MakeBackup

    If using DLM Automation, ReadyRoll or the TeamCity plugin (which uses DLM Automation under the hood) you will need to add an additional pre-deploy step to take a backup.

    To generate a roll-back script in advance (but if upgrade fails, rollback script is unlikely to work either):
    Try adding a build step before your deployment to call DLM Automation with PowerShell or use SQL Compare command line to generate a rollback script and save it as an artifact before executing the deployment.
    AlexYates
    0

Add comment

Please sign in to leave a comment.