Update: I found a faster, more reliable way to import, here
Today when I tried to import a .bacpac file from a customer, I ran across this issue:
Could not load schema model from package. (Microsoft.SqlServer.Dac)
——————————
ADDITIONAL INFORMATION:
Internal Error. The internal target platform type Sql120DatabaseSchemaProvider does not support schema file version ‘2.6’. (File: D:\supportcases\something.bacpac) (Microsoft.Data.Tools.Schema.Sql)
I’m using SQL Server 2014, Developer edition. Searching for the error returns no matched result. However, as the file was exported by Azure v12, we can assume Microsoft should have done something to support the latest version (2.6) in Management Studio.
The solution: Download and install SQL Server 2014 Service Pack 1:
https://www.microsoft.com/en-us/download/details.aspx?id=46694
Even better, after installing SP1, update to the “SP1 Latest Cumulative Update”, which can be downloaded here:
https://www.microsoft.com/en-us/download/details.aspx?id=51186
Note that you can’t install the Cumulative Update directly.
Now you can import the .bacpac file export in 2.6 version.
This is not the end of the story, I got a newer file and this time, another error:
Could not load schema model from package. (Microsoft.SqlServer.Dac)
——————————
ADDITIONAL INFORMATION:
Internal Error. The internal target platform type SqlAzureV12DatabaseSchemaProvider does not support schema file version ‘2.9’. (File: D:\supportcases\something.bacpac) (Microsoft.Data.Tools.Schema.Sql)
SqlAzureV12DatabaseSchemaProvider does not support schema file version ‘2.9’
Ahhh, it’s turn out that I’ll have to install SQL Server Management Studio 2016 from
https://msdn.microsoft.com/en-us/library/mt238290.aspx?f=255&MSPPError=-2147217396
It’s a pretty big package – more than 800MB. It’ll take some time to download and install. But at least it’s free. It’s only the “shell” – you can still work with the SQL Server engine from older version (2008-2014)
And now it’s imported successfully:
