Search code examples
sql-serverbacpac

importing SQL Server .bacpac file

I've been trying (and failing) to import a SQL .bacpac file to SQL 2014 Express. Does anyone know if it's even possible to import these to Express? I haven't found anything online saying otherwise, but thinking of just getting the developer edition to try that instead. For info here is the error I get

Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.Sql130DatabaseSchemaProvider 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)

thanks

Solution

  • The '130' database level is SQL 2016, but you are attempting to restore it to a SQL 2014 database. SQL Server backups have never been backward compatible.