Azure SQL Error – “The model version ’3.5’ is not supported”

Hi Folks,

Are you working with Azure SQL and facing issues? – Me too!

PROBLEM:

I was trying to restore a .bacpac file to my SQL server in Azure and encountered with below error.

“Could not read schema model header information from package. (Microsoft.SqlServer.Dac)

Additional Information:

The model version ’3.5’ is not supported. (Microsoft.Data.Tools.Schema.Sql)”

SOLUTION:

The first and obvious solution should be try upgrading the SQL Management studio to the latest version. However, for me it took little time to find this out.

So, before going any further just open your SSMS (Sql Server Management Studio)  and click on the “Resource Center” under help and download the latest version of SSMS.

OR

Get it from here: https://msdn.microsoft.com/en-us/library/mt238290.aspx

Install and upgrade your SSMS. It should look like below.

Open SQL Server Management Studio -> Help -> About

Try restoring your .bacpac file again!

Dont know how to restore the .bacpac file?

Try following this: https://msdn.microsoft.com/en-us/library/hh710052.aspx

You will be happy to see below result.

Enjoy the Cloud!

– Gopal Shah

#Azure #SQL #SSMS #Windows