Azure-Sql-Database

將 SQL Azure Bacpac 導入 SQL Server 2014 LocalDb 時出錯

  • June 19, 2016

下載了 v12 SQL Azure bacpac,並嘗試將其導入 SQL Server 2014 LocalDB ……我得到:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Could not load schema model from package. (Microsoft.SqlServer.Dac)

------------------------------
ADDITIONAL INFORMATION:

Internal Error. The database platform service with type     Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid.     You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. (Microsoft.Data.Tools.Schema.Sql)

------------------------------
BUTTONS:

OK
------------------------------

我已經嘗試安裝 Data-Tier Framework Jan 2016 Preview,它沒有任何區別(x64 和 x86)。

有什麼建議?

原來解決方案非常簡單,您需要確保安裝了 sql Server 2014 sp1。不敢相信我錯過了!

引用自:https://dba.stackexchange.com/questions/133330