Deploying a database to rollback

jonv

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 ?

Thanks
Jon

Chris.Allen

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.