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