导入BACPAC失败，＆QUOT;不含QueryStoreStaleQueryThreshold＆QUOT; [英] Import bacpac fails with "does not contain QueryStoreStaleQueryThreshold"

问题描述

我正尝试导入从Azure的SQL数据库BACPAC文件，管理工作室2014年时，下面的错误。
我已经升级Azure的SQL数据库V12，并怀疑它是与此有关，但它的工作原理与一些V12数据库和失败一些。

有谁知道如何解决这个问题？

  

无法从包中加载的架构模式。 （Microsoft.SqlServer.Dac）

  
  

------------------------------附加信息：

  
  

元素或注记类SqlDatabaseOptions不包含
  属性类QueryStoreStaleQueryThreshold。
  （Microsoft.Data.Tools.Schema.Sql）

解决方案

让我试试在这里帮助。我们已经看到其他用户报告这个时候他们还启用了新的索引顾问功能。没有与这里的问题的详细说明以及一种解决方法。 <一href=\"https://social.msdn.microsoft.com/Forums/azure/en-US/ac9deff4-e0fe-4de0-98ec-9059e917e0bc/database-export-bacpacs-can-no-longer-be-imported-sqldatabaseoptions-querystoredesiredstate?forum=ssdsgetstarted\">https://social.msdn.microsoft.com/Forums/azure/en-US/ac9deff4-e0fe-4de0-98ec-9059e917e0bc/database-export-bacpacs-can-no-longer-be-imported-sqldatabaseoptions-querystoredesiredstate?forum=ssdsgetstarted

I am getting the error below when trying to import bacpac file from Azure sql database with management studio 2014. I have upgraded the Azure sql database to v12 and suspect it has something to do with this, but it works with some v12 databases and fails on some.

Does anyone know how to resolve this?

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

------------------------------ ADDITIONAL INFORMATION:

The Element or Annotation class SqlDatabaseOptions does not contain the Property class QueryStoreStaleQueryThreshold. (Microsoft.Data.Tools.Schema.Sql)

解决方案

Let me try and help here. We've seen other users report this when they have also enabled the new Index Advisor feature. There is a workaround along with a detailed description of the issue here. https://social.msdn.microsoft.com/Forums/azure/en-US/ac9deff4-e0fe-4de0-98ec-9059e917e0bc/database-export-bacpacs-can-no-longer-be-imported-sqldatabaseoptions-querystoredesiredstate?forum=ssdsgetstarted

这篇关于导入BACPAC失败，＆QUOT;不含QueryStoreStaleQueryThreshold＆QUOT;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！