How can we help you today? How can we help you today?

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
Bugmeister
0

Comments

2 comments

Sort by
  • DanC
    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!
    DanC
    0
  • Bugmeister
    OK Dan I haven't seen a reoccurrence since but if I do I'll raise a support ticket.  Thanks.
    Bugmeister
    0

Add comment

Please sign in to leave a comment.