Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
Stored Procedure Backup
-
Hi,
Does this tool takes the backup of stored procedure to rollback the changes?
How to rollback the database related changes?Product: BuildMaster
Version: 4.8.0 -
It can do that, but it won't automatically. You have to configure the deployment plans. Think of the deployment plans as a script that will run each time you deploy to an environment.
For stored procedures, those should be treated as code and kept in source control, as they can be recreated simply with a DROP/CREATE/CONFIGURE script file. This way, they can be redeployed like any other artifact (i.e. extracted to some directory and executed from disk).
As mentioned in the previous post, DDL/DML database changes cannot be automatically rolled back because once you DROP a column, it's gone for good until you restore from backup. Configuring a deployment plan to take a database backup is probably a good idea in this case :) You could go one step further and configure the deployment plan to restore from that backup on some condition if you really wanted to, but I would hope once the deployment is automated that these failed deployments will be kept to a minimum.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login