Error importing SQL Azure V12 BACPAC. "Failed to read the schema model header information from the package. Model version" 3.5 "is not supported

Question

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

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

Starting November 8, 2016, this command started with an error:

*** Database import error: could not read the schema model header information from the package. Version "3.5" is not supported.

This is similar to the previous problem we encountered in April. Azure V12 BACPAC SQL Import Error: "The type of the internal target platform SqlAzureV12DatabaseSchemaProvider does not support the version of the schema file" 3.3 "

This time was associated with the maxdop configuration area. This time, this is another new configuration option that has just appeared (from the model.xml file):

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

Why did this property seemingly accidentally appear in the model.xml file?

Answer 1

I ran into the same problem. There is a new structure for data-tier applications.

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

https://www.microsoft.com/en-us/download/details.aspx?id=53876

I installed it and imported from the bacpac files with sqlpackage.exe again.

Hope this helps!

ps. I am on a 64-bit machine and had to install both 32-bit and 64-bit frame upgrades.