Solution: 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)

If you get the following error, then you need to install BOTH x86 and x64 versions of the DAC Framework. I have only verified that this works with SQL Express 2014.

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

The other option is to install the 2016 preview tools, but I haven’t tried that.

https://msdn.microsoft.com/en-us/library/mt238290.aspx

TITLE: Microsoft SQL Server Management Studio

——————————

Could 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

——————————

===================================

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

——————————

Program Location:

at Microsoft.SqlServer.Dac.DacPackage.LoadModel(IPackageSource packageSource, Boolean ignoreUnresolvedExternalErrors)

at Microsoft.SqlServer.Dac.Extensions.DacExtensions.GetCollationString(IPackageSource packageSource)

at Microsoft.SqlServer.Dac.Extensions.DacExtensions.GetCollationString(BacPackage package)

at Microsoft.SqlServer.Management.Dac.DacWizard.CreateDatabaseOnTargetWorkItem.DoWork()

at Microsoft.SqlServer.Management.TaskForms.SimpleWorkItem.Run()

===================================

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)

——————————

Program Location:

at Microsoft.Data.Tools.Schema.Extensibility.ExtensionTypeLoader.InstantiateDatabaseSchemaProvider(String databaseSchemaProviderType)

at Microsoft.Data.Tools.Schema.Extensibility.ExtensionManager.UpdateExtensions()

at Microsoft.Data.Tools.Schema.Extensibility.ExtensionManager..ctor(String databaseSchemaProviderType)

at Microsoft.Data.Tools.Schema.Extensibility.ExtensionManager.GetExtensionManager(String dsp)

at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.DeserializeXml(TextReader input, ErrorManager errors, String source, Action 3 constructorParametersSetter)

at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.DeserializePackage(SqlPackage package, ErrorManager errors, Action 3 constructorParametersSetter)

at Microsoft.SqlServer.Dac.DacPackage.DeserializePackage(SqlPackage package, DacSchemaModelStorageType modelStorageType, ErrorManager errorManager, DataSchemaModelHeader& header)

at Microsoft.SqlServer.Dac.DacPackage.LoadModel(IPackageSource packageSource, Boolean ignoreUnresolvedExternalErrors)

Share