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?
.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?