SQL Azure V12 BACPAC导入错误. “无法从包中读取模式模型头信息.不支持模型版本"3.5" [英] SQL Azure V12 BACPAC import error. "Could not read schema model header information from package. The model version '3.5' is not supported

问题描述

我们每晚都对Azure V12数据库进行bacpac，然后使用命令

We take bacpacs of our Azure V12 database every night and restore locally using the command

C:\ Program Files(x86)\ Microsoft SQL 服务器\ 120 \ DAC \ bin>.\ SqlPackage.exe/a:导入/sf:C:\1.bacpac/tdn:db1 /tsn:server1

C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin>.\SqlPackage.exe /a:Import /sf:C:\1.bacpac /tdn:db1 /tsn:server1

从2016年11月8日开始，此命令开始失败，并显示以下内容:

As of 8 Nov 2016, this command has started failing with :

***导入数据库时​​出错:无法从包中读取模式模型头信息.不支持模型版本"3.5".

*** Error importing database:Could not read schema model header information from package. The model version '3.5' is not supported.

这看起来类似于我们在四月的此过程中遇到的先前问题

This looks similar to a previous problem we had with this process back in April SQL Azure V12 BACPAC import error: "The internal target platform type SqlAzureV12DatabaseSchemaProvider does not support schema file version '3.3'"

那是由于maxdop的作用域配置选项所致.这次，这似乎是刚刚出现的另一个新配置选项(来自model.xml):

That time is was due to a scoped configuration option of maxdop. This time it appears to be another new configuration option which has just appeared (from the model.xml):

<Property Name="TemporalHistoryRetentionEnabled" Value="False" />

为什么此属性似乎随机出现在model.xml中?

Why has this property seemingly randomly appeared in the model.xml ?

推荐答案

我遇到了同样的问题.有一个新的数据层应用程序框架.

I ran into the same issue. There is a new data tier applications framework.

我花了几个小时才找到它.......

It took me a few hours to find it.......

https://www.microsoft.com/zh-我们/download/details.aspx?id=53876

我安装了它，并且使用sqlpackage.exe从bacpac文件导入的文件再次起作用.

I installed it and my imports from bacpac files with sqlpackage.exe work again.

希望有帮助！

ps.我在64位计算机上，必须同时安装32位和64位框架升级.

ps. I am on a 64 bit machine and had to install both the 32 and 64 bit framework upgrade.

这篇关于SQL Azure V12 BACPAC导入错误. “无法从包中读取模式模型头信息.不支持模型版本"3.5"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！