Forum Discussion
Advocate IIIPromoting warehouse from Test to Prod
You can use DACPAC functionality to do the entire deployment:
Sample references:https://stackoverflow.com/questions/60347552/azure-devops-how-to-execute-pre-and-post-deployment-sql-scripts
https://www.kevinrchant.com/2023/10/25/ci-cd-for-microsoft-fabric-data-warehouses-using-yaml-pipelines/
Super UserYou can use DACPAC functionality to do the entire deployment:
Sample references:
https://stackoverflow.com/questions/60347552/azure-devops-how-to-execute-pre-and-post-deployment-sql-scripts
https://www.kevinrchant.com/2023/10/25/ci-cd-for-microsoft-fabric-data-warehouses-using-yaml-pipelines/
KimTuteinHi NandanHegde
Thank you very much for your response and reference I will look into the links you provided.
In our old setup in Synapse Dedicated pool we use Dacpac deployment via. a visual studio database project. The little testing I have done with sql projects has been with Azure Data Studio (I have some problems getting the extention to wok in VS Code). As written in documentation for instance adding a new field to a table will delete the contens of a table - which I find a bit disappointing. As we have decided to put most of our data in a Lakehouse and only make a schema in a warehouse available for some appartments I might just populate theese schemas and grants via. a script task using normal pipelines and a control table in our lakehouse.