Unable to import .bacpac files exported from Azure

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.

The version after update
The version after update

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'

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:

Import version 2.9 bacpac with SQL Server Management Studio 2016
Import version 2.9 bacpac with SQL Server Management Studio 2016

Leave a Reply

Your email address will not be published. Required fields are marked *