Post-deployment scripts in SQL project with Azure Data Studio

Mikko Tanner 1 Reputation point

I have created a SQL database project using Azure Data Studio, based on a existing database.
I can successfully deploy a new database with it.

How can I include post-deployment script(s) to the project, using Azure Data Studio ?
All the advice seems to concern Visual Studio only.

Further more, is it possible to include data load logic to the project in Azure Data Studio, other than script insert-statements ?

PS. there is no tag for Azure Data Studio ....

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,581 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. YufeiShao-msft 7,051 Reputation points

    Hi @Mikko Tanner ,

    Azure Data Studio has similar features to SSMS, use SSDT to define post deployment scripts in vs is a commonly used method.
    If your tool used involved Azure, you may also consider using Azure data factory.
    About data load logic, you may consider using SSIS


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.