Using a new stored proc in a migration script


My understanding, is that migration scripts run before the Programmable Objects, so my new stored procedure is not available to my migration script.

I can create the sp in the migration script (or one executed before), but I don't like this duplication of code...
Is there a solution I'm missing?


Éric Lamontagne

Best Answer

  • DanCDanC Posts: 553 Gold 4
    Hi @EricLamontagne

    Ah, I understand and unfortunately, that would require a drastic change to the way SQL Change Automation works and we're moving towards Flyway and Flyway Desktop as part of our Redgate Deploy package for the future of DB Devops so I can't see this feature being implemented for SCA

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our 
    Help Center?


Sign In or Register to comment.