Does Azure Synapse SQL DW deployment is similar to SQL DB deployment?

user_14714363 0
Viewed 335

I am designing a Azure Synapse SQL DW CI-CD pipeline. Is CI/CD logic is same for Azure Synapse SQL (formerly SQL DW) and SQL DB, which is to create a DACPAC file and deploy?

Does anyone has deployed or have some poc?

azure-sql-data-warehouse azure-sqldw azure-synapse azure-sql-database azure-devops
2 Answers

Using Visual Studio 2019 you can create a project type of SQL Server Database Project (you may have to install), set the project type to Microsoft Azure SQL Data Warehouse and that will work for dedicated SQL pools.

VS2019 and SSDT projects

For serverless SQL pools, this is not supported at this time. You can however use the Azure DevOps DACPAC deployment task to deploy SQL scripts only rather than compiled DACPACs.

In Azure DevOps, make sure the agent you use is Windows 2019 or above as that will have the right version of sqlpackage.exe.

user_15275040

Here is one example of a pipeline to deploy Azure Synapse:

strategy:
  runOnce:
    deploy:
      steps:
      - task: SqlAzureDacpacDeployment@1
        displayName: 'Azure SQL DacpacTask - ProjectA'
        inputs:
          azureSubscription: '[subscription-name]'
          ServerName: '$(database-server)'
          DatabaseName: '$(database-name)'
          SqlUsername: '$(database-user)'
          SqlPassword: '$(database-user-password)'
          DacpacFile: '$(Pipeline.Workspace)/_dacpac/database.dacpac'
user_169638670
Related