CODEWITHSUNDEEP
azure-devopsazure-synapsedacpac
sac
sac

Reputation: 215

dacpac creation from Azure Synapse dedicated SQL Pool using Azure DevOps

I have created the sql dacpac file from azure SQL database using Devops pipeline inbuilt task 'Azure SQL database deployment'. Now I am trying to create dacpac file from azure synapse SQL Pool. but I didn't find any related task or PowerShell script to do the same.

can you please pour your valuable suggestion?

Thanks

Upvotes: 0

Views: 940

Answers (1)

Nandan
Nandan

Reputation: 4925

You can leverage the same task for SQL Dedicated pool deployment as well. There is no separate task for it

My blogs for reference : https://datasharkx.wordpress.com/2021/03/11/automated-deployment-of-azure-sql-database-azure-sql-data-warehouse-through-azure-devops-via-service-principal-part-1/ https://datasharkx.wordpress.com/2021/03/12/automated-deployment-of-azure-sql-database-azure-sql-data-warehouse-through-azure-devops-via-service-principal-part-2/

To create a DACPAC, in build pipeline you can leverage visual studio build task with latest version. enter image description here

Upvotes: 2

Related Questions