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

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


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...)


Please download the latest version of SSMS from here, it may solve the issue.

It seems a known issue the error you are receiving. On this Microsoft blog post, they were successful restoring to a SQL Server 2012 instance using SSMS 2014.

You will find more workarounds and solutions on this StackOverflow thread.


1st we need to check, In version of .bacpac is creted. the higher version will support lower version of .bacpac, but lower version will not support will higher version of .bacpac.