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

posted @ 2013-05-23 20:22  liudao  阅读(593)  评论(0编辑  收藏  举报
51Aspx.com 版权所有