Hello, I am trying to implement automatically deployment of SQL Dedicated Pool from one environment to the other using DACPAC. I am using visual studio code as my IDE. i was able to connect to the database and was able to build the .sqlproj file. However when i try to deploy the dacpac file. i get the following error A project which specifies Microsoft Azure SQL Database v12 as the target platform cannot be published to Azure Synapse Dedicated SQL Pool. I am pretty much sure its about this line of code in sqlproj file.

@Admin (KK) Thanks for posting your question in the Microsoft Q&A forum The error message "Could not resolve SDK 'Microsoft.SqlServer.DACNAVSynapseSqlPool'" indicates that Visual Studio Code cannot locate the necessary SDK for deploying to Azure Synapse Dedicated SQL Pool. Here's how to address this issue: 1. Install the Microsoft.SqlServer.DACNAVSynapseSqlPool SDK: Open a terminal or command prompt in Visual Studio Code. Run the following command to install the required NuGet package: Bash dotnet add package Microsoft.SqlServer.DACNAVSynapseSqlPool This command will download and install the missing SDK into your project. 2. Verify Installation: After running the command, rebuild your project using: Bash dotnet build If the SDK was installed correctly, the build process should now succeed without the "Could not resolve SDK" error. Ensure you have a stable internet connection during the installation process. Microsoft.SqlServer.DACNAVSynapseSqlPool SDK: https://video2.skills-academy.com/en-us/sql/relational-databases/data-tier-applications/deploy-a-data-tier-application?view=sql-server-ver16 Hope this helps. Do let us know if you any further queries.

Thanks for posting your question in the Microsoft Q&A forum. To deploy a DACPAC to an Azure Synapse Dedicated SQL Pool, you need to use the Microsoft.SqlServer.DACNAVSynapseSqlPool SDK instead of the Microsoft.Build.Sql SDK, which is designed for Azure SQL Database. Update your .sqlproj <PropertyGroup> <TargetPlatformIdentifier>SynapseDedicatedSQLPool</TargetPlatformIdentifier> </PropertyGroup> <Sdk Name="Microsoft.SqlServer.DACNAVSynapseSqlPool" Version="1.0.0.0" /> Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

Issue with DACPAC deployment of SQL Dedicated Pool

Accepted answer

phemanth 8,080 Reputation points Microsoft Vendor

2024-06-18T05:59:16.8733333+00:00
@Admin (KK)

Thanks for posting your question in the Microsoft Q&A forum

The error message "Could not resolve SDK 'Microsoft.SqlServer.DACNAVSynapseSqlPool'" indicates that Visual Studio Code cannot locate the necessary SDK for deploying to Azure Synapse Dedicated SQL Pool.

Here's how to address this issue:

1. Install the Microsoft.SqlServer.DACNAVSynapseSqlPool SDK:

Open a terminal or command prompt in Visual Studio Code.

Run the following command to install the required NuGet package: Bash dotnet add package Microsoft.SqlServer.DACNAVSynapseSqlPool

This command will download and install the missing SDK into your project.

2. Verify Installation:

After running the command, rebuild your project using: Bash dotnet build

If the SDK was installed correctly, the build process should now succeed without the "Could not resolve SDK" error.

Ensure you have a stable internet connection during the installation process. Microsoft.SqlServer.DACNAVSynapseSqlPool SDK: https://video2.skills-academy.com/en-us/sql/relational-databases/data-tier-applications/deploy-a-data-tier-application?view=sql-server-ver16

Hope this helps. Do let us know if you any further queries.
Please sign in to rate this answer.
Admin (KK) 131 Reputation points

2024-06-18T15:02:53.9666667+00:00

Hello, I tried , but i get this error message and i also searched in nuget.org, i dont see any package with that name.

Unable to find package Microsoft.SqlServer.DACNAVSynapseSqlPool. No packages exist with this id in source(s): nuget.org

phemanth 8,080 Reputation points Microsoft Vendor

2024-06-19T09:07:40.7233333+00:00

@Admin (KK) The error message you’re seeing typically means that the NuGet package you’re trying to install doesn’t exist in the NuGet repository. If the package is not available on NuGet, it might be a proprietary or custom package that isn’t publicly available.

For deploying DACPACs to Azure Synapse Dedicated SQL Pool, you would typically use the Microsoft.SqlServer.Dac package, which contains the DacServices class for deploying DACPACs. However, this package targets SQL Server and Azure SQL Database, and there might be compatibility issues with Azure Synapse Dedicated SQL Pool.

As an alternative, you could consider using Azure Data Studio or SQL Server Management Studio (SSMS) for deploying DACPACs to Azure Synapse. These tools have built-in support for DACPAC deployment and might be easier to use in this scenario.

Admin (KK) 131 Reputation points

2024-06-19T12:59:31.2866667+00:00

Thanks, do you have some sort of article to deploy the scripts through pipeline to different environments.

phemanth 8,080 Reputation points Microsoft Vendor

2024-06-19T16:09:31.04+00:00

@Admin (KK)

How can you target environments in a Azure YAML Pipeline via deployment: This Stack Overflow thread discusses how to target different environments in an Azure YAML Pipeline via a deployment job. It provides a complete YAML pipeline example for deploying pipeline artifacts to VM resources in a specific environment.

Azure Pipelines using YAML for multiple environments (stages) with different variable values but no YAML duplication: This Stack Overflow thread discusses how to use YAML for multiple environments (stages) with different variable values but without YAML duplication. It provides an example of a shared pipeline config that gets included into environment-specific pipelines.

Best Practices for a multi environment deployment using Jenkins: This article discusses best practices for a multi-environment deployment using Jenkins. It recommends using software that makes your deploy as simple and repeatable as possible (e.g., Ansible, Terraform, Cloud Formation, or Kubernetes).

A Complete Guide to Azure DevOps Pipelines with YAML Templates: This guide provides a comprehensive overview of Azure DevOps Pipelines with YAML templates. It explains how to define your build and deployment processes as code using YAML configuration files for consistency and repeatability.

These resources should provide you with a good starting point for deploying scripts through a pipeline to different environment Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

phemanth 8,080 Reputation points Microsoft Vendor

2024-06-20T08:53:12.25+00:00

@phemanth Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sign in to comment

Share via

Issue with DACPAC deployment of SQL Dedicated Pool

1 additional answer