Comments
2 comments
-
Hi Diego @dbuenosilva
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
-
Thanks @DanC
Let me try it! I will post the results soon.
Add comment
Please sign in to leave a comment.
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