Re-deploy all stored procedures regardless previous deployments
dbuenosilva
Posts: 5 New member
Hi there,
When a stored procedure is modified directly in the database, and its changes are not pushed to the repo, a new deployment will not overwrite the altered stored procedure in the database if it new version is not uploaded to the repo.
Is the default SCA process? I wonder if there is a way to re-deploy all stored procedures always without the need to delete the sp records from ___MigrationLog table.
Regards,
Diego
When a stored procedure is modified directly in the database, and its changes are not pushed to the repo, a new deployment will not overwrite the altered stored procedure in the database if it new version is not uploaded to the repo.
Is the default SCA process? I wonder if there is a way to re-deploy all stored procedures always without the need to delete the sp records from ___MigrationLog table.
Regards,
Diego
Tagged:
Answers
This sounds like drift handling to me and we have the following document which will help you with this:
https://documentation.red-gate.com/sca/deploying-database-changes/automated-deployments-with-sql-change-automation-projects/handling-schema-drift
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Let me try it! I will post the results soon.