What are the challenges you face when working across database platforms? Take the survey

Can SCA deploy always Views before Stored Procedures?

Hi there,

We often have developers creating stored procedures that depend on views being created at the same task.

SCA automatically creates the stored procedures in the "Programmable objects" -> <schema> -> "Stored Procedures" folder and views in the "Programmable objects" -> <schema> -> "Views" folder.

As a result, it tries to deploy the stored procedure first, then the views.

To avoid the error, I have to edit the SCA project and change the Deployment Order manually using Visual Studio. It is timing consuming since we have to drag view by view...

Is there a way to define this deployment order defined?

I am unsure if it is possible to rename the directories "Stored Procedures" and "Views". Following these names it would work:
2-Stored Procedures





Sign In or Register to comment.