SQL Azure V12 BACPAC导入错误。 “无法从包中读取模式模型标头信息。不支持模型版本'3.5'

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

我们每晚都会使用Azure V12数据库的bacpacs，并使用该命令在本地恢复

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

C：\ Program Files（x86）\ Microsoft SQL Server \ 120 \ DAC \ bin>。\ SqlPackage.exe / a：导入/sf:C:\1.1.bacpac / tdn：db1 / tsn：server1

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

截至2016年11月8日，此命令已失败：

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

***导入数据库时出错：无法从包读取模式模型头信息。不支持型号版本“3.5”。

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'”

这看起来类似于我们在4月份使用此过程时遇到的问题SQL Azure V12 BACPAC导入错误：“内部目标平台类型SqlAzureV12DatabaseSchemaProvider不支持模式文件版本'3.3'”

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):

那个时间是由于maxdop的范围配置选项。这次它似乎是刚刚出现的另一个新配置选项（来自model.xml）：

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

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

为什么这个属性似乎随机出现在model.xml中？

1 个解决方案

#1

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/en-us/download/details.aspx?id=53876

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

我安装它，我从bacpac文件导入sqlpackage.exe再次工作。

Hope that helps!

希望有所帮助！

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

PS。我在64位机器上，不得不安装32位和64位框架升级。

#1