SQL Server bacpac无法在最新更新中本地导入(在线索引操作只能在SQL Server企业版中执行) [英] SQL Server bacpac fails on local import in latest update (Online index operations can only be performed in Enterprise edition of SQL Server)

问题描述

我有一个SQL Azure数据库，并在SQL Server Management Studio中连接到它.我确实要导出数据层应用程序，然后为 .bacpac 文件导入数据层应用程序，以将其放入我的localdb中.或者我使用任务-部署数据库".

I have an SQL Azure database and connect to it in SQL Server Management Studio. I do Export Data Tier Application and then Import Data Tier Application for the .bacpac file to get it into my localdb. Or I use Tasks - Deploy Database.

无论哪种方式，它都可以工作到最近，但现在我得到一个错误

Either way, it worked up until recently and now I get an error

只能在企业版SQL Server中执行在线索引操作

Online index operations can only be performed in Enterprise edition of SQL Server

我正在使用下面的SQL Server Management Studio版本(来自帮助-关于").有什么想法吗?

I am using SQL Server Management Studio versions below (from Help - About). Any ideas?

SQL Server Management Studio                    15.0.18369.0
SQL Server Management Objects (SMO)             16.100.46041.41
Microsoft Analysis Services Client Tools        15.0.19342.0
Microsoft Data Access Components (MDAC)         10.0.19041.1
Microsoft MSXML                                 3.0 6.0 
Microsoft .NET Framework                        4.0.30319.42000
Operating System                                10.0.19041

推荐答案

如果您可以升级到或使用SQL Server 2019 Developer Edition，而不必使用localdb，则不会有任何问题.Developer Edition是免费的，并且具有与Enterprise Edition相同的功能.您可以从此处下载Developer Edition，然后进行更新并在此处之后使用最新的累积更新尝试将bacpac导入到Developer Edition实例中.

If instead of using localdb you can upgrade to or use SQL Server 2019 Developer Edition, then you won't have any issues. Developer Edition is free and has the same features as Enterprise Edition. You can download Developer Edition from here and then update it with the latest cumulative update from here, after that try to import the bacpac to the Developer Edition instance.

这篇关于SQL Server bacpac无法在最新更新中本地导入(在线索引操作只能在SQL Server企业版中执行)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！