SqlAzureDatabaseSchemaProvider錯誤的解決

把SQL Azure的bacpac資料檔案在本地匯入的時候會出現下面類似的錯誤：

內部目標平台類型 SqlAzureDatabaseSchemaProvider 不支援架構檔案版本“2.5”。(檔案: D:\demo.bacpac) (Microsoft.Data.Tools.Schema.Sql)

需要更新一下DAC架構即可，請按照下文進行下載安裝

Error Restoring SQL Azure DB to SQL Server 2012

Today I attempted to restore a SQL Azure bacpac file to my local SQL Server 2012 instance and got cold-cocked by a big, ‘ol error message:

“ Internal Error. The internal target platform type SqlAzureDatabaseSchemaProvider does not support schema file version '2.5'. (File: [BACPAC FILE NAME]) (Microsoft.Data.Tools.Schema.Sql)”

Looks like the SQL Server Data Tools team pushed out an update in December for the tools. A simple install fixed me up and I was able to restore my DB without errors.

The update contains a number of enhancements to several parts of the tool: Database Unit Testing Integration with SSDT Power Tools Updated Data-Tier Application Framework (This is the part that makes Azure restores work again!) Bug Fixes

The SSDT update can be downloaded here:

SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015

SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014

More info on the updates can be found here:

http://blogs.msdn.com/b/ssdt/archive/2012/12/13/available-today-ssdt-december-2012.aspx