Post-deployment scripts in SQL project with Azure Data Studio

Mikko Tanner 1 Reputation point
2022-08-17T06:42:21.29+00:00

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
    2022-08-18T08:09:18.14+00:00

    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.