Order of changes? Altering tables before stored procedures that reference them?
Bugmeister
Posts: 21 New member
Hi,
I had a CI failure today because in the SCA update script a stored procedure ALTER was done before an ALTER TABLE to add a column that the procedure now referenced.
How is the order of changes worked out by SCA? Would it be possible to somehow apply all the table changes before the procs/functions/everything else? Would there be an issue doing it that way? If not then how roughly would I achieve it (I'm using the SQL Source Control and git, and the Powershell cmdlets in Azure DevOps).
Thanks
Peter
I had a CI failure today because in the SCA update script a stored procedure ALTER was done before an ALTER TABLE to add a column that the procedure now referenced.
How is the order of changes worked out by SCA? Would it be possible to somehow apply all the table changes before the procs/functions/everything else? Would there be an issue doing it that way? If not then how roughly would I achieve it (I'm using the SQL Source Control and git, and the Powershell cmdlets in Azure DevOps).
Thanks
Peter
Tagged:
Best Answer
-
DanC
Posts: 637 Gold 5
Hi @Bugmeister
This looks like it might be a potential bug, I'll need some more resources from you to escalate this to the development team.
What I'll do is reach out via a support ticket!Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Answers