Deploying a database to rollback

jonvjonv Posts: 4
edited November 20, 2014 9:16AM in SQL CI 2
Hi RedGate,

Is the following scenario possible :

Database packaged and sent to Octopus Deploy as v1.1.
Deployment made and the database is upgraded to v1.1 from v1.0, but one of the installers fails (lets say web)
Now I want to rollback the release to the original version (v1.0) of the database before this release.

Can the SQL Automation Pack move databases backwards (v1.0 from v.1.1) as well as forwards (v1.0 to v1.1) ? Therefore supporting this scenario ?



  • Hi -potentially, yes but you would need to write the powershell scripts that- detect failure and initiate roll-back.

    We'd be happy to help you do that if you want to proceed with a proof of concept.
Sign In or Register to comment.