Order of changes? Altering tables before stored procedures that reference them?

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
Tagged:

Best Answer

  • DanCDanC Posts: 641 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

Sign In or Register to comment.