While trying to publish or preview Auto Schema Update to an Azure SQL Server V12 I'm getting the following error:
Web deployment task failed. (Could not generate deployment script.
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.
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.
Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_EXECUTING_METHOD.)
I found a couple solutions for when this error is encountered when trying to import into a local SQL server, but I'm deploying to Azure SQL Database.
I downloaded and installed Microsoft SQL Server Data-Tier Application Framework (February 2015) (both the x64 and x86 versions as suggested at Unable to import SQL Azure V12 BACPAC: "type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid" but the preview and deploy still fail.
I can connect to the database from my local machine using Microsoft SQL Server Management Studio (13.0.14000.36).
What is missing here?
Updates: I can successfully run Entity Framework's Migration's Update-Database from my local machine. Publishing fails only when 'Update Database' is selected in the wizard (what I'm saying is that my publish setup is OK and works except the database bit).
