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

DeployChangesExecutionOrder is not updated in .sqlproj file

DeepakUDeepakU Posts: 3 New member
edited July 1, 2021 6:51PM in SQL Change Automation
I have added new sql procedure into project. When I configure project and checking for changes, it is showing one sql procedure is added and .sqlproj is updated for <ItemGroup>
    <None Include="Programmable Objects\dbo\Stored Procedures\....</ItemGroup>

.sqlproj is not updated for DeployChangesExecutionOrder and it is causing of deployment of changes into multiple environments using azure pipelines.

Also, I have tried "Import and generate script" but it get hanged visual studio. 
So what are the steps I need to perform to add any store procedures?


Sign In or Register to comment.