Post-deployment scripts in SQL project with Azure Data Studio

Question

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

Answer 1

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.