DACPAC SSDT功能 [英] DACPAC SSDT feature

问题描述

大家好，

我试图通过powershell从已安装VS 2017和预览SSDT的系统发布Azure数据仓库DACPAC。

但我得到以下错误：

类型为Microsoft.Data.Tools.Schema.Sql.SqlDwDatabaseSchemaProvider的数据库平台服务无效。您必须确保服务已加载，或者您必须提供有效数据库平台的完整类型名称。

SO是否有人熟悉错误？

什么是  Microsoft.Data.Tools.Schema.Sql.SqlDwDatabaseSchemaProvider是什么意思？

我需要安装一些东西吗？

因为在同一系统中，我可以通过VS 2017发布DACPAC。

PowerShell还需要进行任何额外的安装吗？

解决方案

您好Priya，

来自
SQL Server PowerShell doc（这是一个关于SQL PowerShell所有内容的优秀资源）是  安装SQL Server PowerShell
模块说明。您需要确保使SqlServer PowerShell模块保持最新。 

一个好的测试是在
Azure Cloud Shell 以及在本地PS环境中查看一个环境是否成功。只要模块已加载，Azure Cloud Shell始终是最新的。

我希望这会有所帮助。

Mike

Hi All,

I was trying to publish Azure data warehouse DACPAC via powershell from the system wherein I had installed VS 2017 and the preview SSDT.

But I am getting the below error:

The Database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlDwDatabaseSchemaProvider is not valid.You must make sure the service is loaded,or you must provide the full type name of valid database platform.

SO is someone familiar with the error?

And what does Microsoft.Data.Tools.Schema.Sql.SqlDwDatabaseSchemaProvider mean?

Do I need to install something?

Because from same system I am able to publish the DACPAC via VS 2017.

So does powershell require any additional installations to be done?

解决方案

Hi Priya,

From the SQL Server PowerShell doc (which is a great resource with regard to all things SQL PowerShell) is the Install SQL Server PowerShell module instructions. You need to ensure you keep the SqlServer PowerShell module up to date. 

A good test is to run the same commands in the Azure Cloud Shell as well as in your local PS environment to see if one environment is successful. The Azure Cloud Shell is always at the latest as long as the modules are loaded.

I hope this helps.

Mike

这篇关于DACPAC SSDT功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！