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

Jaimin Soni picture Jaimin Soni · Nov 29, 2017 · Viewed 7.4k times · Source

enter image description here> 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)

I am getting above error when I am restoring Azure SQL Bacpac file in local environment. I have below environment on Azure and Local.

Azure SQL RTM Version : Microsoft SQL Azure (RTM) - 12.0.2000.8 Aug 29 2017 13:06:11 Copyright (C) 2017 Microsoft Corporation

Local Environment SQL RTM Version : Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 (Build 15063: )

Can anyone please suggest the compatible version of Management studio or SQL RTM for above Azure SQL RTM database restore ?

Answer

AlonMichaeli picture AlonMichaeli · May 18, 2018

I haven't managed to solve it through SSMS, the only way that worked was through CMD: "C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\sqlpackage.exe" /a:Import /sf:PATH-TO-BACPAC-FILE /tsn:SERVER-NAME /tdn:DATABASE-NAME /tu:USER-NAME /tp:PASSWORD

  • Replace the upper-cases with your SERVER/DB info.
  • Use correct folder (110,120,130,140...)