How to deploy sql scripts in folder incrementally on Azure SQL Database

Jaya Ojha 65 Reputation points
2023-07-18T07:16:59.03+00:00

Hi,

I am trying to execute the SQL scripts present inside a folder in Azure Repos to the Azure SQL Database incrementally and also wanted to execute the scripts in required sequence. I tried the DACPAC approach which works incrementally but is unable to perform the DML queries such as INSERT and UPDATE etc. It creates the table, procedures etc. Is there any approach that can help me achieve this.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
41,911 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 16,236 Reputation points
    2023-07-18T07:59:02.16+00:00

    Hi
    Jaya Ojha
    •,

    Welcome to the MS Q&A platform.

    The query posted by you is not supported in the Q&A forum. I would request you post your query in the Azure DevOps forum

    This will assist you with a faster reply to your query.

    Hope this will help.

    Thanks

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.