When trying to import a BACPAC file, you could run into the following error.
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)
This is more than likely due to the version of the Client tools you are using. If you created a new database, the default version will be the v12 release. Or you may have upgraded your database to the v12 version.
What's new in SQL Database V12
http://azure.microsoft.com/en-us/documentation/articles/sql-database-preview-whats-new/
If you have a v12 database, and you export it to a BACPAC, you could run into the above error if you are importing it into a lower version of SQL. In my case, I was able to get the error when I tried to import it into SQL 2012 using the Management Studio for SQL 2012.
The issue here is the version of the Client Tools. In my case, Management Studio. If I use the SQL 2014 (v12) version of Management Studio to import that BACPAC to my SQL 2012 server, it works successfully.
You can also get the latest Client Tools from the Azure Portal by going to the Server and clicking on the Quick Start icon and click on Get Microsoft database management tools .
Adam W. Saxton | Microsoft SQL Support - Escalation Services
@GuyInACube
|
Mixes
|
YouTube
|
Facebook.com\guyinacube