0 votes
1 view
in Azure by (45.2k points)

I am trying to import the exported BACPAC from an SQL Azure (v12) database into a local SQL Server 2012 instance, but I keep getting the error below. I have tried installing the DAC and SSDT updates linked from this blog post, but it's not helping.

How can I fix this?

TITLE: Microsoft SQL Server Management Studio

------------------------------

Count not load schema model from package. (Microsoft.SqlServer.Dac)

------------------------------

ADDITIONAL INFORMATION:

Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. (Microsoft.Data.Tools.Schema.Sql)

------------------------------

BUTTONS:

OK

------------------------------

1 Answer

0 votes
by (16.8k points)

In order to fix this import order with [sys].[script_deployment_databases] from exported V12 Database you need to install, Microsoft SQL Server Data Tier Application Framework February 2015 (Make sure you install both the x64 and x86 versions of it)

Check this link: https://www.microsoft.com/en-us/download/details.aspx?id=45886

Also, it is not necessary to install CU13, but in case, just try it, might be helpful:

Cumulative update package 13 for SQL Server 2014

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...